ACCT 2102 Project View Formulas 11 A Data A- A Home Insert Page Layout Calibrl (Body) Copy Paste Format B TUR 14 Axfx Review - E D Ep Wrap Text Merge & Center General $. % 12. 12 Conditional Formas * Formatting as Table Ico E F G H I Directions: Complete requirements 1-3 below. The primary purpose of this assignment is to apply your basic Excel skills to the topics covered in Chapters &. In every cell that requires an entry, you are required to use a cell reference or formula. Do not just enter an amount into a cell. Your grade will be based on the use of cell references and formulas, as well as the accuracy of your answers. Requirement 1 Using the Excel worksheet that appears in Sheet 2, recreate the Review Problem related to Mynor Corporation on pages 362-363. In Sheet 2, you are required to enter a cell reference or formula in every cell with a "?". Do not just enter an amount, as that will defeat the purpose of this Excel assignment. Your answers in Sheet 2 should match the answers on pages 362-363 before you proceed to the next requirement. Requirement 2 Check your worksheet by changing the budgeted unit sales in Quarter 2 of Year 2 in cell cs to 75,000 units. The total expected cash collections for the year should now be $2,085,000. If you do not get this answer, find the errors in your worksheet and correct them. Requirement 3 new marketing manager who insists that unit sales can be dramatically increased by dropp the selling price per unit from $8 to $7. The marketing manager would like to use the following projections in the budget: Year 2 Quarter Year 3 Quarter Budguted unt sales 50.000 70,000 120,000 10,000 90.000 100.000 Soling price per unit S7 por un ACCT 2102 Project Review View Insert Cut Copy Formulas Data 11 P A - A- E Page Layout Calibri (Body) BIU fel Wrap Text Merge & Center General $ % Condition Format Formatti 1 x V C D E G H Yoar 2 Quarter Year 3 Qunter Budgeted unit sales 50,000 70,000 120,000 80,000 90,000 100,000 . Selling price per unit S7 per unit Using the new marketing manager's revised budgeted unit sales and selling price, use cell references to update to these new amounts in Sheet 2 (at the top, in green). If you used cell references and formulas correctly, your spreadsheet should auto-compute the new amounts throughout the spreadsheet. Based on these revised amounts, answer the following questions. Your spreadsheet in Sheet 2 must also support your answers, so be sure to use a cell reference to answers items a-d. What are the total expected cash collections FOR THE YEAR under this revised budget? *Use a cell reference from Sheet 2. Do not just enter an amount. What is the total required production in units FOR THE YEAR under this revised budget? Use a cell reference from Sheet 2. Do not just enter an amount. What is the total cost of raw materials to be purchased FOR THE YEAR under this revised budget? *Use a cell reference from Sheet 2. Do not just enter an amount. What is the total expected cash disbursements for raw materials FOR THE YEAR under this revised budget? *Use a cell reference from Sheet 2. Do not just enter an amount. D @ Home Insert Review View = = = 3 . Page Layout Formulas Data D 10 A- A B I . . . A. fx Wrap Text Merge & Center General $. % ) Copy Format x * F9 . Antarcevable beginning halaga 30the buddunt of the new dia Desiwning fra s tory is she go vertory beginning Ramalan m ed to producerent Derwarding memory of w is is Raw m a tery beginning w a s purchases are paid 10% of the cartes production road otheque 40% the purchase - Accounts payable for en beginning te Remember to enter a cell reference or formule into each of the cells marked with a 7 below. Do not just entera number. Create the sales budget 25 Seling price per unit Create the schedule of expected cash collections Create the production budget 13 Add desired finished goods intory Total 45 Less beginning to Recured producto Sheet1 - Directions Sheet 2 Worksheet MacBook Air ACCT 2102 Project (1) Home Insert Review - - General Page Layout Formulas Data 10 A- A- BIU.L.S.A. fx So Wrap Text Merge & Center - $ . % Copy Format x * . Create the production budget 43 Added do inventory Total 5 Les beginning inventory 5 Meiredo Create the raw materials purchases budget 50 Required production 51 ) punet 53 Addered an inventory of ma p ounds) 4 Total med pounds) 55 Les beginning inventory of raw materials ouds 56 Rear to be purchased 57 Cost of raw materials per pound SE Cost of materials to be purch Create the schedule of expected cash to payments SSRRRRRRRREBBE Book Air ACCT 2102 Project View Formulas 11 A Data A- A Home Insert Page Layout Calibrl (Body) Copy Paste Format B TUR 14 Axfx Review - E D Ep Wrap Text Merge & Center General $. % 12. 12 Conditional Formas * Formatting as Table Ico E F G H I Directions: Complete requirements 1-3 below. The primary purpose of this assignment is to apply your basic Excel skills to the topics covered in Chapters &. In every cell that requires an entry, you are required to use a cell reference or formula. Do not just enter an amount into a cell. Your grade will be based on the use of cell references and formulas, as well as the accuracy of your answers. Requirement 1 Using the Excel worksheet that appears in Sheet 2, recreate the Review Problem related to Mynor Corporation on pages 362-363. In Sheet 2, you are required to enter a cell reference or formula in every cell with a "?". Do not just enter an amount, as that will defeat the purpose of this Excel assignment. Your answers in Sheet 2 should match the answers on pages 362-363 before you proceed to the next requirement. Requirement 2 Check your worksheet by changing the budgeted unit sales in Quarter 2 of Year 2 in cell cs to 75,000 units. The total expected cash collections for the year should now be $2,085,000. If you do not get this answer, find the errors in your worksheet and correct them. Requirement 3 new marketing manager who insists that unit sales can be dramatically increased by dropp the selling price per unit from $8 to $7. The marketing manager would like to use the following projections in the budget: Year 2 Quarter Year 3 Quarter Budguted unt sales 50.000 70,000 120,000 10,000 90.000 100.000 Soling price per unit S7 por un ACCT 2102 Project Review View Insert Cut Copy Formulas Data 11 P A - A- E Page Layout Calibri (Body) BIU fel Wrap Text Merge & Center General $ % Condition Format Formatti 1 x V C D E G H Yoar 2 Quarter Year 3 Qunter Budgeted unit sales 50,000 70,000 120,000 80,000 90,000 100,000 . Selling price per unit S7 per unit Using the new marketing manager's revised budgeted unit sales and selling price, use cell references to update to these new amounts in Sheet 2 (at the top, in green). If you used cell references and formulas correctly, your spreadsheet should auto-compute the new amounts throughout the spreadsheet. Based on these revised amounts, answer the following questions. Your spreadsheet in Sheet 2 must also support your answers, so be sure to use a cell reference to answers items a-d. What are the total expected cash collections FOR THE YEAR under this revised budget? *Use a cell reference from Sheet 2. Do not just enter an amount. What is the total required production in units FOR THE YEAR under this revised budget? Use a cell reference from Sheet 2. Do not just enter an amount. What is the total cost of raw materials to be purchased FOR THE YEAR under this revised budget? *Use a cell reference from Sheet 2. Do not just enter an amount. What is the total expected cash disbursements for raw materials FOR THE YEAR under this revised budget? *Use a cell reference from Sheet 2. Do not just enter an amount. D @ Home Insert Review View = = = 3 . Page Layout Formulas Data D 10 A- A B I . . . A. fx Wrap Text Merge & Center General $. % ) Copy Format x * F9 . Antarcevable beginning halaga 30the buddunt of the new dia Desiwning fra s tory is she go vertory beginning Ramalan m ed to producerent Derwarding memory of w is is Raw m a tery beginning w a s purchases are paid 10% of the cartes production road otheque 40% the purchase - Accounts payable for en beginning te Remember to enter a cell reference or formule into each of the cells marked with a 7 below. Do not just entera number. Create the sales budget 25 Seling price per unit Create the schedule of expected cash collections Create the production budget 13 Add desired finished goods intory Total 45 Less beginning to Recured producto Sheet1 - Directions Sheet 2 Worksheet MacBook Air ACCT 2102 Project (1) Home Insert Review - - General Page Layout Formulas Data 10 A- A- BIU.L.S.A. fx So Wrap Text Merge & Center - $ . % Copy Format x * . Create the production budget 43 Added do inventory Total 5 Les beginning inventory 5 Meiredo Create the raw materials purchases budget 50 Required production 51 ) punet 53 Addered an inventory of ma p ounds) 4 Total med pounds) 55 Les beginning inventory of raw materials ouds 56 Rear to be purchased 57 Cost of raw materials per pound SE Cost of materials to be purch Create the schedule of expected cash to payments SSRRRRRRRREBBE Book Air