If work could be included thst would be great!
1. Sales Budget. (4 points): Flower Pot (FP) Company plans to sell the following units at a selling price of $35.00 each: 4th atr 1st gtr 4th at 2nd 1st qtr 21.000 18.000 34.000 69,000 24,000 19,000 38.000 2nd qtr 3rd gt. Prepare the necessary sales budget FP Company Sales Budget For the Year Ended 12/31/2019 1st qtr_2nd qtr_3rd gatr Budgeted Unit sales Sales price per unit Total Sales 4th gtr 4th gr 1st otr. 2nd qtr 2. Production budget (13 points):Determine the number of units to produce given that ending inventory needs to be 15% of next quarter sales units. FP Company Production Budget For the Year Ended 12/31/2019 3rd qtr 4th otr Year 1st atr 2nd qtr 1st otr. 2nd qtr Budgeted units to sell Add: ending inv Total needed Less: Begin Inv Budgeted units to produce Total production units for the year 1st at 2nd gtc 3. Materials budget (13 points):Complete the Materials budget given that each unit produced requires $6.25 of materials and that ending inventory needs to be 10% of next quarter production needs FP Company Direct Materials Budget For the Year Ended 12/31/2019 3rd atr 4th gtc Total 15 gtc Budgeted production units Direct Material unit $ cost Direct materials $ needed for production Add: ending DM inv $ Total DM $ needed Less: Begin DM $ Inv Budgeted purchases of Direct materials $ 4. Labor budget (6 points) Prepare the direct labor budget given that each unit produced requires .25 labor hours at a rate of $14 per hour FP Company Direct Labor Budget For the Year Ended 12/31/2019 2nd att 3rd atr 184 gtc. 4 gtc Total Budgeted production units Direct labor hours needed per unit Direct labor needed for production Direct labor cost per hour Budgeted Direct Labor cost 5. Manufacturing OH budget (10 points): Prepare the Manufacturing Overhead budget given that Variable Overhead costs are $.50 per unit produced and Fixed overhead costs per quarter for depreciation is $30,000 for depreciation and $45,000 for Factory utilities, insurance and property taxes, Overhead is allocated based on Direct labor hours FP Company Manufacturing Overhead Budget For the Year Ended 12/31/2019 Total Variable OH Costs: Budgeted production units Variable OH per unit Budgeted Variable OH 15 gr 2nd to 3rd atc. 4th gtc. Budgeted Fixed OH -Depreciation -Utilities, Ins, Prop tax Total Budgeted Fixed OH Budgeted total OH Divided by Total Budgeted Direct Labor Hours needed = Predetermined OH allocation rate per labor hour_(Bud OH / budgeted DL brs)
