Insert Data Review View brow Page Layout Liberation Sans 12 Developer Formulas A A Tell me Formats Cales 1 23.1A Prepare budgeted income statement and supporting budgets 2 Cook Farm Supply Company manufactures and sells a pesticide called Share. The following data are available for preparing budget for Snare for the first quarter of 2017 1 Expected sales bags of Snare) Quarter 1 Quarter 40.000 50.000 Price per bag Price per bag 5000 500.00 2 Direct Materials per bag of Snare) Ingredient Name Gurm Pounds Needed Caster Pound 13. Desired inventory levels Type try Budgeted Ending inventory Levels Q1 2010 01. 2017 02 2017 15.000 18.000 10.000 13.000 20.000 25.000 Gurmpounds N . 19 4. Director $18.00 DLH 025 DLH bag 3 Using the information , prepare the budget below in the o rgan As is the case for every worksheet in every wherever po a ch COOK FARM SUPPLY COMPANY Sales Budget Fort Worth Ending 30.2017 W T Asool os lock M Home Insert Data Tell me Review EE View Developer Custom Draw Page Layout Formulas Liberation Sans 12 AA BTUH OA fx 04 2016 Conditional Formatting Formatos Table col Styles Paste $ %983 C14 x COOK FARM SUPPLY COMPANY Sales Budget For the Six Months Ending June 30, 2017 As s , each cell requires a formu Expected unit sales Unit selling price Value COOK FARM SUPPLY COMPANY Production Budget For the Sox Months Ending June 30, 2017 PSIS Expected units es Add Desired ending finished goods units Total required units 47 Loss Beginning finished goods units Required production units The the Direct Materials COOKTAR SUPPLY COMPANY Direct Materials Budget - Gurm For the Six Months Indiana June 30, 2017 6 units to be produced 57 Direct manals per units) Total pounds needed for production 55 Add: Desired ending direct mawr obs) Total is required Low Beginning direct materials ) Direct material purchase 4 Total cost of direct purchases Mode 10 a 12 ock Data Review View Developer Tell me Custom 1 Insert Draw Page Layout Formulas Liberation Sans 12 A A BIU CA x v fx 'Q4 2016 Conditional Formatting Format as Table Coll Styles E D $ % 9 8 * C14 As always, each cell requires a formula COOK FARM SUPPLY COMPANY Sales Budget For the Six Months Ending June 30, 2017 Quarter 1 2 Value Value Value Value SEX Months 34 Expected unit sales 35 Unit selling price 36 Total sales Value SEX COOK FARM SUPPLY COMPANY Production Budget For the Six Months Ending June 30, 2017 Quarter 1 2 44 Expected unit sales Value Vale Value 45 Add: Desired ending finished goods units Value Value 46 Total required units 47 Less: Beginning finished goods units Value Value 48 Required production units Months 7 COOK FARM SUPPLY COMPANY Direct Materials Budget Gumm For the Six Months Ending June 30, 2017 Quarter Please note this is the Direct Materials budget for the Gumm Ingredient only!!! Mont Value Value Value Value Value Valve 56 Units to be produced 57 Direct materials per unit (lbs.) 58 Total pounds needed for production 59 Add: Desired ending direct materials (lbs.) s0 Total materials required 61 Less: Beginning direct materials (lbs.) 62 Direct materials purchases 63 Cost per pound 4 Total cost of direct materials purchases Value Value Value Value Introduction Module 10 Module 12 +