# Sweats Galore Case 6

Topics: Variable cost, Costs, Fixed cost Pages: 10 (1812 words) Published: February 21, 2012
SWEATS GALORE
1.Yes, it is important for Michael to stipulate certain criteria during planning for his new business. Michael is wise to set criteria other than simply making a profit. First, Michael wants to do something he enjoys. Because he has prior experience in a related industry and he has envi¬sioned having his own business he will be better prepared to handle the responsibilities of this new business. Michael’s positive attitude will be reflected in the way he handles employees and customers. Michael’s business will probably come from customers such as university groups, church groups, civic organizations, youth athletic clubs, and secondary school groups. Because Michael is offering quality shirts at a modest price, he will, in effect, be contributing to the community. In addition, as Michael’s company becomes more profitable he will give back to the community through cash donations to some of these groups. Michael’s foresight (wanting to grow and be more successful every year) will encourage him to make decisions that will profit the business not just in the short run, but also in the long run. 2.The difference in the high and low levels of activity is 6,000 units (8,000 units in September less 2,000 units in January). The difference in utility costs is \$300 (\$1,400 – \$1,100). Therefore, estimated variable cost per unit is \$.05 and total fixed costs are \$1,000 computed as follows:

\$300 ÷ 6,000 = \$.05
\$1,400 – (\$.05 X 8,000) = \$1,000
The difference in maintenance costs is \$198 (\$1,914 – \$1,716). Therefore, estimated variable cost per unit is \$.033 and total fixed costs are \$1,650 computed as follows:
\$198 ÷ 6,000 = \$.033
\$1,914 – (\$.033 X 8,000) = \$1,650
If Michael has sales of \$12,000, the units sold total 750 (\$12,000 ÷ \$16). Therefore his total variable costs relating to utilities and maintenance for 750 shirts total \$62.25 computed as follows:

750 shirts X \$.05 = \$37.50
750 shirts X \$.033 = \$24.75
If Michael has sales of \$12,000, the total fixed costs would be \$2,650 (\$1,000 + \$1,650).
CASE 6 (Continued)

3.
SWEATS GALORE
Sales Budget
For the Year Ending December 31, 2008

Quarter
1234Year
Expected unit sales8,00010,00020,00012,00050,000
Unit selling priceX \$16X \$16X \$16X \$16X \$16 Budgeted sales revenue\$128,000\$160,000\$320,000\$192,000\$800,000

4.
SWEATS GALORE
Schedule of Expected Collections from Customers
For the Year Ending December 31, 2008

Quarter
1234
Accounts receivable 1/1/08-0-
First quarter (\$128,000)\$89,600\$ 38,400
Second quarter (\$160,000)112,000\$ 48,000
Third quarter (\$320,000)224,000\$ 96,000
Fourth quarter (\$192,000) 134,400 Total collections\$89,600\$150,400\$272,000\$230,400

5.

SWEATS GALORE
Shirt Purchases Budget
For the Year Ending December 31, 2008

Quarter
1234Year
Shirts to be silk-screened8,00010,00020,00012,00050,000 Plus: Desired ending inventory 2,500 5,000 3,000 4,500 4,500 Total shirts required10,50015,00023,00016,50054,500 Less: Beginning inventory -0- 2,500 5,000 3,000 -0- Total shirts needed10,50012,50018,00013,50054,500

Cost per shirt* \$10 \$10 \$10 \$10 \$10 Total cost of shirt purchases\$105,000\$125,000\$180,000\$135,000\$545,000

*\$1,440 ÷ 144 (a gross)

CASE 6 (Continued)

6.

SWEATS GALORE
Schedule of Expected Payments for Purchases
For the Year Ending December 31, 2008
Quarter
1234
Account payable 1/1/08-0-
First quarter (\$105,000)\$42,000\$ 63,000
Second quarter (\$125,000)50,000\$ 75,000
Third quarter (\$180,000)72,000\$108,000
Fourth quarter (\$135,000) 54,000 Total payments\$42,000...