Calibri 11 AT ab v General Paste BI UV V A $ ~ % 9 Recover Unsaved Workbooks. We were able to save changes to one or more files. Do you want to recover them? A15 A F G Problem 1: BUDGETING You will complete the following budgets for the year (by quarter) in a professional format (complete with appropriate labels, subtotals, and 3 calculations). 4 1. Sales Budget 5 2. Production Budget 6 3. Cost of goods sold Budget 7 4. Selling and admin expense budget (or operating expense budget) 8 5. Budgeted Income Statement 9 6. Cash Budget (including schedules of cash receipts from customers and cash payments for purchases) 10 11 Additional information you will need for Sales Budget: Pick your Company Name and the product you will sell. Budgeted sales units have been provided for you in the Sales Budget and your budgeted sales price is $98 per unit. 12 13 14 Budget Project for Manufacturing Company: (Enter your company name here) 15 16 (Enter your company name here) 17 Sales Budget 18 1st Qtr 2nd Qtr 3rd Qtr 4th Qtr YEAR Points A 19 Sales (in Units) 12,510 13,140 13,400 14,070 53,120 Points 20 21 22 23 What type of company is this (meaning, what product are you making)? 24 25 26 27 Additional information you will need for Production Budget: Company policy is to maintain 35% of next quarter's sales units in finished goods inventory. First quarter's beginning finished goods inventory is estimated at 4379 units. Fourth quarter's ending finished goods inventory is estimated at 4974 units. 28 20 Project Settings + DEC 32 5 MacBook Air .O 20 esc F1 F2 F3 F4 F5 F6