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
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. April sales (in units) will be 30,000, May's sales will be 29,000, and June's sales will be 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. REMARKS SALES BUDGET 2019 JANUARY FEBRUARY MARCH APRIL MAY JUNE JULY JFMAM J J UNIT SALES Given 0 0 0 0 0 0 0 PRICE PER UNIT Giver 0 0 0 0 0 0 0 SALES REVENUE Multiply 0 0 0 0 0 0 0 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. Prepare a Production budget for the first 6 months of 2019. PRODUCTION BUDGET 2019 JANUARY FEBRUARY MARCH APRIL MAY JUNE JULY JFMAM JJ UNIT SALES 26,000 See Sales Budget 0 0 0 0 0 0 1 + DESIRED ENDING INVENTORY 30% of next month sales oo oo oo SUBTOTAL Sum 0 0 0 0 0 0 - BEGINNING INVENTORY Last month's Ending Inv. oo oo oo UNITS TO PRODUCE Units to Produce 0 0 0 0 0 0 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 MAY JUNE JULY JF MAM J J UNITS TO PRODUCE 26,000 From Prod. Budget 0 0 0 0 0 0 DIRECT MATERIAL PER UNIT 4 Pounds per unit 0 0 0 0 0 0 1 MATERIAL REQ'D FOR PRODUCTION 104,000 Multiply 0 0 0 0 0 0 1 + ENDING MATERIAL INVENTORY 20% of next month's SUBTOTAL Sum - BEGINNING MATERIAL INVENTORY Last month's Ending Inv oo oo oo UNITS TO PURCHASE Units to Purchase 0 0 0 0 0 0 PRICE PER UNIT Cost Per Unit 0 0 0 0 0 0 TOTAL MATERIAL PURCHASES Multiply
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance