Question

In: Accounting

Blue Devil Corporation manufactures and sells wireless keyboards. Expected sales of keyboards for upcoming months are...

Blue Devil Corporation manufactures and sells wireless keyboards. Expected sales of keyboards for upcoming months are as follows: March 50,000 April 55,000 May 60,000 June 52,000 July 58,000 November 37,000 December 39,000 Management likes to maintain a finished goods inventory equal to 20% of the next month's estimated sales. Required: Prepare the company's production budget for the second quarter of this year. Include a column for each month and a total column for the entire quarter.

Solutions

Expert Solution

Production budget for 2nd quarter :

April May June 2nd quarter
Expected sales units 55,000 60,000 52,000 167,000

(+) Desired ending inventory

[ 20% of the next month's expected sales ]

12,000

[ 20% * 60,000 ]

10,400

[ 20% * 52,000 ]

11,600

[ 20% * 58,000 ]

11,600
Total units required 67,000 70,400 63,600 178,600
(-) Beginning inventory ( 11,000 ) ( 12,000 ) ( 10,400 ) ( 11,000 )
Units to be produced 56,000 58,400 53,200 167,600

NOTE : 1) Ending inventory of one month becomes the opening inventory of the immediate next month. Ending inventory of March month will be 20% of the April month's expected sales units which comes to 11,000 units [ i.e. 20% * 55,000 ] and these 11,000 units will become the opening inventory of April month. Similarly the ending inventory of April and May month is taken to be the opening inventory of May and June month respectively.

2) As the second quarter ends with the end of June month. the ending inventory of June month is taken to be the ending inventory of second quarter and as the second quarter starts from April month, the opening inventory of April month is taken to be the opening inventory of second quarter.


Related Solutions

Blue DevilCorporation manufactures and sells wireless keyboards. Expected sales of keyboardsfor upcoming months are as follows:March50,000April55,000May60,000June52,000July58,000November37,000December39,000Management...
Blue DevilCorporation manufactures and sells wireless keyboards. Expected sales of keyboardsfor upcoming months are as follows:March50,000April55,000May60,000June52,000July58,000November37,000December39,000Management likes to maintain a finished goods inventory equal to 20% of the next month's estimated sales.Required:Prepare the company'sproduction budget for the secondquarter of this year. Include a column for each month and a total column for the entire quarter.
RyRy, Inc. manufactures dance apparel. Unit sales projections for the first five months of the upcoming...
RyRy, Inc. manufactures dance apparel. Unit sales projections for the first five months of the upcoming year are as follows: January 3500 February 3,800 March 3,300 April 4800 May 5,000 Beginning finished goods inventory consisted of 750 units. The desired inventory of units at the end of each month in the upcoming year should equal 25% of the following month’s budgeted unit sales. Each unit requires 4 yards of fabric. The company wants to have 20% of the fabric required...
RyRy, Inc. manufactures dance apparel. Unit sales projections for the first five months of the upcoming...
RyRy, Inc. manufactures dance apparel. Unit sales projections for the first five months of the upcoming year are as? follows Month Unit Sales January 3,400 February ?3,800 March ?3,300 April 4,900 May                       ?5,000 Beginning finished goods inventory consisted of 950 units. The desired inventory of units at the end of each month in the upcoming year should equal? 25% of the following? month’s budgeted unit sales. Each unit requires 2 yards of fabric. The company wants to have? 20% of...
4) Fab Manufacturing Corporation manufactures and sells stainless steel coffee mugs. Expected mug sales at Fab...
4) Fab Manufacturing Corporation manufactures and sells stainless steel coffee mugs. Expected mug sales at Fab (in units) for the next three months are as follows:Fab likes to maintain a finished goods inventory equal to 30% of the next month's estimated sales. How many mugs should Fab plan on producing during the month of November?   23,200 mugs   26,800 mugs   25,900 mugs   34,300 mugs
National Co. manufactures and sells three products: red, white, and blue. Their unit sales prices are...
National Co. manufactures and sells three products: red, white, and blue. Their unit sales prices are red, $46; white, $76; and blue, $101. The per unit variable costs to manufacture and sell these products are red, $31; white, $51; and blue, $71. Their sales mix is reflected in a ratio of 2:2:1 (red:white:blue). Annual fixed costs shared by all three products are $141,000. One type of raw material has been used to manufacture all three products. The company has developed...
National Co. manufactures and sells three products: red, white, and blue. Their unit sales prices are...
National Co. manufactures and sells three products: red, white, and blue. Their unit sales prices are red, $47; white, $77; and blue, $102. The per unit variable costs to manufacture and sell these products are red, $32; white, $52; and blue, $72. Their sales mix is reflected in a ratio of 5:4:2 (red:white:blue). Annual fixed costs shared by all three products are $142,000. One type of raw material has been used to manufacture all three products. The company has developed...
National Co. manufactures and sells three products: red, white, and blue. Their unit sales prices are...
National Co. manufactures and sells three products: red, white, and blue. Their unit sales prices are red, $53; white, $83; and blue, $108. The per unit variable costs to manufacture and sell these products are red, $38; white, $58; and blue, $78. Their sales mix is reflected in a ratio of 5:4:2 (red:white:blue). Annual fixed costs shared by all three products are $148,000. One type of raw material has been used to manufacture all three products. The company has developed...
National Co. manufactures and sells three products: red, white, and blue. Their unit sales prices are...
National Co. manufactures and sells three products: red, white, and blue. Their unit sales prices are red, $46; white, $76; and blue, $101. The per unit variable costs to manufacture and sell these products are red, $31; white, $51; and blue, $71. Their sales mix is reflected in a ratio of 2:2:1 (red:white:blue). Annual fixed costs shared by all three products are $141,000. One type of raw material has been used to manufacture all three products. The company has developed...
Galaxy Lighting Company manufactures and sells lighting fixtures. Estimated sales for the next three months are:...
Galaxy Lighting Company manufactures and sells lighting fixtures. Estimated sales for the next three months are: September $ 350,000 October $ 500,000 November $ 400,000 Sales for August were $400,000 and December is estimated as $420,000. All sales are on account. Galaxy Lighting Company estimates that 80% of the accounts receivable are collected in the month of sale with the remaining 20% collected the following month. The units sell for $40 each. Generally, 60% of purchases are due and payable...
Meredith Company has budgeted sales for the upcoming months as follows: April $ 458,000 May $...
Meredith Company has budgeted sales for the upcoming months as follows: April $ 458,000 May $ 469,000 June $ 498,000 July $ 517,000 August $ 501,000 September $ 482,000 40% of the sales are credit sales, the remainder are made in cash. Credit sales are collected 50% in the month of sale, 35% in the month following the sale, and 6% in the second month following the sale. a. Compute Meredith Company’s cash receipts for June. (Do not round intermediate...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT