Question: can you please provide clear answer B C D Exercise Number (1 ONLY) E F 1 ALT-SALES-PROD Ferndale Company is preparing budgets for 2019. Ferndale


can you please provide clear answer
B C D Exercise Number (1 ONLY) E F 1 ALT-SALES-PROD Ferndale Company is preparing budgets for 2019. Ferndale estimates that unit sales in January will be 22,000 units, February sales will be 24,000 units, and March sales will be 28,000 units. 12 13 April sales (in units) will be 30,000, May's sales will be 29,000, and June's sales will be 14 27,000. July's sales are estimated at 26,000 units. The product is priced at $16.00 per unit. Prepare a Sales Budget for the first 6 months of 2019. SALES BUDGET 2019 JANUARY FEBRUARY MARCH UNIT SALES PRICE PER UNIT SALES REVENUE 24 Ferndale wishes to end each month with inventory equal to 30.00% of the following month's sales. The December 2018 inventory was 3,500 units. 26 Prepare a Production budget for the first 6 months of 2019. APRIL MARCH MAY JANUARY FEBRUARY PRODUCTION BUDGET 2019 UNIT SALES + DESIRED ENDING INVENTORY SUBTOTAL - BEGINNING INVENTORY UNITS TO PRODUCE Ferndale's product requires 4 pounds of material at a cost of $3.50 per pound. The company wishes to end each month with 20% of the next month's material required for production. The materiale inventory at the beginning of the year war 20.000 pounde TABLEROONDPA2522 15 8 16 9 10 11 17 6 18 19 23 27 28 20 29 21 30 31 32 33 34 35 36 37 28 4 P ALT-SALES-PROD G APRIL H MAY JUNE JUNE K REMARKS Given Given Multiply JULY 26,000 See Sales Budget JULY LMNOPQR JFMAM J 3 00 80 O 0 00 00 00 O O 00 ao 00 J 1 JFMAMJ 00 0000 00 00 C 0 00 00 00 00 000 00 00 00 30% of next month sales Sum Last month's Ending Inv. Units to Produce S 0990 7:44 PM 5/25/202 APRIL 22 PRICE PER UNIT 23 SALES REVENUE 25 Ferndale wishes to end each month with inventory equal to 30.00% of the following month's sales. The December 2018 inventory was 3,500 units. 26 27 Prepare a Production budget for the first 6 months of 2019. 28 29 PRODUCTION BUDGET 2019 JANUARY FEBRUARY MARCH APRIL 30 UNIT SALES 31 + DESIRED ENDING INVENTORY SUBTOTAL - BEGINNING INVENTORY UNITS TO PRODUCE Ferndale's product requires 4 pounds of material at a cost of $3.50 per pound. The company wishes to end each month with 20% of the next month's material required for production. The materials inventory at the beginning of the year was 20,000 pounds. Prepare a Direct Materials Budget JANUARY FEBRUARY MARCH APRIL UNITS TO PRODUCE DIRECT MATERIAL PER UNIT MATERIAL REQ'D FOR PRODUCTION + ENDING MATERIAL INVENTORY SUBTOTAL - BEGINNING MATERIAL INVENTORY UNITS TO PURCHASE PRICE PER UNIT TOTAL MATERIAL PURCHASES 2 3 4 ALT-SALES-PROD MAY MAY MAY JUNE JUNE JUNE MEMARKS Given Given Multiply JULY 26,000 See Sales Budget JULY JFMAM J 00 00 00 00 00 00 0000 00 0 30% of next month sales Sum Last month's Ending Inv Units to Produce JULY 26,000 From Prod. Budget 4 Pounds per unit 104,000 Multiply -00 JFMAM J J 00 00 1 00 80 00 00 00 00.0000 J J.F M A M J 0.000 0 0 1 00 0 O 1 00 G 01 1 20% of next month's 00 00 0 Sum 0 0 00 O 0 0000 0 0 Last month's Ending Inv Units to Purchase Cost Per Unit 00 0 0 0 0 00 00 00 000000 Multiply ooooo praat oo 6000 6
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
