Question

In: Accounting

A company expects to sell 6,000 units in April and expects sales to increase 20% each...

  1. A company expects to sell 6,000 units in April and expects sales to increase 20% each month after. The unit sales price of $8 is expected to remain constant. The company wants ending finished goods inventory to be 15% of the next month’s sales.
  1. What are budgeted sales revenues for the second quarter?
  1. How many units will be produced in the second quarter? Round answers to nearest whole number.
  1. The raw materials ending inventory should be 20% of the next month’s production needs. Assuming each unit requires 4 feet of material that costs $3 per foot, what is the cost of May purchases?
  1. Monthly manufacturing overhead is budgeted to be $15,000 per month plus $8 per unit produced. What is budgeted manufacturing overhead for May?
  1. If each unit required 0.75 hours of labor, and the labor wage is $9/hr, what is budgeted DL cost for May?

Solutions

Expert Solution

1) April May June Total July
Budgeted Sales Unit 6000 7200 8640 21840 10368
Unit Price 8 8 8
Budgeted Sales Revenue 48000 57600 69120 174720
Final Answer $174720
April May June Total July Aug
2) Total Units to be sold            6,000            7,200            8,640          21,840 10368      12,442
Add: Ending Inventory Required            1,080            1,296            1,555          1,866
Less: beginning Inventory Available                   -              1,080            1,296          1,555
Units to be produced            7,080            7,416            8,899         23,395       10,679
Final Answer 23395 Units
3) April May June July
Total Units to be produced            7,080            7,416            8,899          10,679
Requirement per unit                     4                    4                    4                    4
Raw material units required          28,320          29,664          35,597          42,716
Add: Ending Inventory Required            5,933            7,119            8,543
Less: beginning Inventory Available                   -              5,933            7,119            8,543
Units to be produced          13,013            8,603          10,323
Cost per unit 3 3 3 3
Cost of purchase          39,038          25,808          30,969                   -  
Final Answer (may cost of purchase) $25808
4) April May June
Total Units to be produced            7,080            7,416            8,899
Variable manufacturing OH per unit                     8                    8                    8
Variable manufacturing OH          56,640          59,328          71,194
Fixed manufacaturing OH          15,000          15,000          15,000
Total manufacturing OH          71,640          74,328          86,194
Final Answer (may overhead) $74328
5) April May June
Total Units to be produced            7,080            7,416            8,899
labour hr per unit               0.75              0.75              0.75
labour hr required            5,310            5,562            6,674
labour cost per hr                     9                    9                    9
labour cost          47,790          50,058          60,070
Final Answer (may labor cost) $50058

Related Solutions

Baker Company sells one product. Management estimates that the company will sell 6,000 units of the...
Baker Company sells one product. Management estimates that the company will sell 6,000 units of the product each year. The relevant information about the product line of Baker Company for the year ended December 31, 2014 appears below: Breakeven units: 4,000 units Variable expenses per unit: Direct Material: $35 Direct labour: $25 Variable production overhead: $30 Fixed expenses: Fixed Production overhead $190,000 per annum Fixed selling and administrative $50,000 per annum There was no inventory in stock at the beginning...
A company expects to sell 500 tables in April, 700 in May, and 650 in June....
A company expects to sell 500 tables in April, 700 in May, and 650 in June. The company sells these tables for $120 per unit. 30% of its sales are cash sales and 70% of its sales are credit sales. Please construct a sales budget for April, May and June. A company’s sales budget shows the following:                                         April              May                 June Cash Sales                     $5,000        $7,000            $8,000 Credit Sales                $20,000       $28,000          $32,000 The company had credit sales of $10,000 in February...
4. If a company expects to sell 4,500 units, has a DOL of 2 and a...
4. If a company expects to sell 4,500 units, has a DOL of 2 and a % change in Operating Cash Flow of 22% (positive), how many units did they actually sell? a.  400 b.  440 c.  4,440 d.  4,995 e.  None of the above 5.  Which of the following is FALSE about the efficient markets hypothesis? a.  EMH implies that the market has already incorporated characteristics such as dividend policy into its price. b.  EMH is the idea that actual capital markets, such as the NYSE, are...
Becker Bikes manufactures tricycles. The company expects to sell 460 units in May and 590 units...
Becker Bikes manufactures tricycles. The company expects to sell 460 units in May and 590 units in June. Beginning and ending finished goods for May is expected to be 150 and 115 units, respectively. June’s ending finished goods is expected to be 125 units. Each unit requires 3 wheels at a cost of $16 per wheel. Becker requires 20 percent of next month’s material production needs on hand each month. July’s production units is expected to be 560 units. Compute...
Becker Bikes manufactures tricycles. The company expects to sell 510 units in May and 640 units...
Becker Bikes manufactures tricycles. The company expects to sell 510 units in May and 640 units in June. Beginning and ending finished goods for May is expected to be 175 and 140 units, respectively. June’s ending finished goods is expected to be 150 units. The company’s variable overhead is $10.50 per unit produced and its fixed overhead is $11,000 per month. Compute Becker’s manufacturing overhead budget for May and June. (Do not round intermediate calculations. Round your final answers to...
The Haskins Company manufacturs and sells radios. The Haskins Company expects to sell 25,100 units of...
The Haskins Company manufacturs and sells radios. The Haskins Company expects to sell 25,100 units of its product at $11.10 per unit and to incur variable costs per unit of $6.10. Total fixed costs are $71,000. The total contribution margin for Haskins Company is:
1- Swansong plans to sell 10,000 units of a particular product during July, and expects sales...
1- Swansong plans to sell 10,000 units of a particular product during July, and expects sales to increase at the rate of 10% per month during the remainder of the year. The June 30 and September 30 ending inventories are anticipated to be 950 units and 1,100 units, respectively. On the basis of this information, how many units should Swansong purchase for the quarter ended September 30? Select one: a. 32,950 units b. 33,250 units c. 31,850 units d. 34,750...
The manager at​ Tom's Taxidermy expects to sell 900 units at​ $80 each unit. In order...
The manager at​ Tom's Taxidermy expects to sell 900 units at​ $80 each unit. In order for the manager to​ breakeven, the manager must sell 100 units. What is the margin of safety in​ dollars? $72,000 $79,000 $80,000 $64,000
A toy manufacturer expects to sell 4536 games in a year. The games cost $20 each...
A toy manufacturer expects to sell 4536 games in a year. The games cost $20 each plus a fixed delivery cost of $140 per order. If it cost $5 to store a game for a year, find the order size and the number of orders that minimizes inventory costs.  
LongHorn Corp is analyzing a proposed project. The company expects to sell 10,000 units, plus or...
LongHorn Corp is analyzing a proposed project. The company expects to sell 10,000 units, plus or minus 4 percent. The expected variable cost per unit is $10 and the expected fixed costs are $400,000. The fixed and variable cost estimates are considered accurate within a plus or minus 10 percent range. The depreciation expense is $61,000. The tax rate is 32 percent. The sales price is estimated at $70 a unit. What is the operating cash flow under the best...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT