*****NEEDS TO BE IN EXCEL-need help please!!**** I have posted everything needed
ID: 2587139 • Letter: #
Question
*****NEEDS TO BE IN EXCEL-need help please!!**** I have posted everything needed for this project
The facts for this problem are presented on the Facts tab of this workbook. |instructions - Your solutions should be clearly labeled on the Solutions tab of this workbook. For the first quarter of 2017, do the following. (a) Prepare a sales budget. This is similar to slustration 21-3 on page 1088 of your textbook. (b) Prepare a production budget. This is similar to Illustration 21-5 on page 1089 of your textbook. (C) Prepare a direct materials budget. (Round to nearest dollar) This is similar to illustration 21-7 on page 1091 of your textbook. (d) Prepare a direct labor budget. (For calculations, round to the nearest hour.) This is similar to illustration 21-9 on page 1094 of your textbook. (e) Prepare a manufacturing overhead budget. (Round intermediate amounts to the nearest dollar.) This is similar to Sllustration 21-10 on page 1094 of your textbook. (f) Prepare a selling and administrative budget. This is similar to illustration 21-11 on page 1095 of your textbook. (e) Prepare a budgeted income statement. (Round intermediate calculations to the nearest dollar.) This is similar to Illustration 21-13 on page 1096 of your textbook. (h) Prepare a cash budget. This is similar to slustration 21-17 on page 1100 of your textbook. (You will need to prepare schedules for expected collections from customers and expected payments to vendors first. See Illustrations 21-15 and 21-16 on page 1099 of your textbook for guidance.) Rules: * Use Excel's functionality to your benefit. Points are lost for lack of formula. - Use proper formats for schedules, following the referenced textbook examples. "Use dollar-signs and underscores where appropriate. * Double-check your workl Verify your formula and logici Grading Guidelines: Effective Use of Excel Facts, Logic Completeness Spelling, Punctuation, Value Format 40% 20% 30% 10%Explanation / Answer
(c) Direct Material Budget
(f) Selling and Administrative Budget
(a)Sales Budget January February March April Sales (units) 100,000 101,000 103,000 112,000 Per unit selling price $11.00 $11.00 $11.00 $11.00 Total Sales ($) 1,100,000 1,111,000 1,133,000 1,232,000Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.