Master Budgets

Using excel to prepare an operating budget

(manufacturing company)

Thunder Creek Company is preparing budgets for

the forst quarter of 2018. All relevant information is

presented on the excel template.

use the blue shaded areas on the ENTER-

ANSWERS tab for inputs. Use cell references and

formulas please!! :)

Thunder Creck Company expects sales of 19,000 units in January 2018, 25,000 units in February, 51.000 units in March 35,000 in April, and 37.000 in May. The sales price is $3$ per unit Prepare a sales budget 2018 Budget : Sales Budget Jan Feb Mar Q1 Total April May Hudgeted units to be sold Sales priceperit Total Sales Thunder Creek wants to finish each month with 20% of Death's sales in units Prepare a production budget. (When entering answers in the production budget, use the sales budget for your cell references, Emerall values as positive without a minus sign-in row 18) Hint: Beginning inventory for the period is equal to the ending inventory of the previous period, 2017 Dec Jan Feb Mar 01 Total April May Budget 2: Production Badget Haluted units to be sold Plus: Desired unitsin ending inventory Total units weed Lew Units in beaning inventory Bled units to be prowed Thunder Creek Company uses 3 pounds of direct materials for each unit it produces, at a cost of $5.00 per pound. The company begins the year with 10.500 pounds of material in Raw Materials Inventory Management desires an ending inventory of 25% of next month's materials requirements Prepare a Direct Materials Budget. (When entering answers in the direct materials budget, use the production budget for your cell references. Erster all values as positive--without a minus sign-in row 31) 2018 Mar Feb Ol Total April Budget 3: Direct Materials Budget Badgeted units to be produced Direct materials (pounds) per unit Direct materials needed for production Plus: Desired direct materials in ending inventory (pounds) Total direct materials needed Less: Direct materials in beginning inventory (pounds) Hulgeted purchase or direct materials Direct material cost per pound Budgeted cost of direct materials purchases QI Total Thunder Creck Company's workers require 30 minutes of labor to produce each unit of product. The labor cost is $22 per hour Prepare a Direct Labor Budget (When entering answers in the direct labor budget, use the direct materials budget for your cell references) 2018 Budget 14. Direct Labor Budget Jan Feb Mar Budgeted units to be produced Direct labor hours per un Direct labor hours teeded for production Direct labor cost per hour Badgeted direct laboral