Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need help in this question. Please do this in excel and show the formulas to how to enter the answers in the box as
I need help in this question. Please do this in excel and show the formulas to how to enter the answers in the box as shows in the picture because i have to put formula in the box to calculate the answer. Please do correctly
$ 15.00 10 11 BASE DATA: 12 Foundation Data for Solving questions 1, 2 and 3: 13 14 Budgeted Direct Materials Cost Per UNIT 15 16 Budgeted Direct Manufacturing Labor Per UNIT 17 18 Budgeted Manufacturing Overhead Per UNIT 19 20 $ 10.00 $ 5.00 A B D $ 20.00 18,108 Units 20 21 IN ADDITION TO ABOVE USE THE FOLLOWING: 22 23 24 This is Next Year's Budgeted Data for XYZ 25 26 Budgeted Sales Price Per UNIT 27 28 Budgeted Sales - UNITS 29 30 Target Ending Finished Goods Inventory in UNITS 31 32 Target Beginning Finished Goods Inventory in UNITS 33 34 Target Ending Direct Materials Inventory in UNITS 35 36 Target Beginning Direct Materials Inventory in UNITS 37 38 Note: It takes one unit of direct materials to make one production unit. 5,608 Units 4,958 Units 11,608 Units 9,608 Units 0 A B 39 40 WITH THE ABOVE DATA SOLVE THE FOLLOWING QUESTIONS REGARDING YOUR PRODUCT: 41 42 1 How many units should be produced next year? 43 44 Record your answer, using excel formulas, here 45 46 2) What is the dollar amount budgeted for direct material purchased for next year? 47 48 Record your answer, using excel formulas, here 49 50 3) What is the Budgeted Revenues for next year. 51 52 Record your answer, using excel formulas, here 53 54 13,716 21,216 8,716 June 53 54 55 USE ONLY THE FOLLOWING INFORMATION TO ANSWER THIS QUESTION. DO NOT USE ANY INFORMATION FROM ABOVE. 56 57 Gamble Company has the following sales budget for the last six months: 58 January S 16,216 April S 59 February S 18.216 May S 60 March S 10,216 $ 61 62 Historically, the cash collection of sales has been as follows: 63 The % of sales collected in the month of sale is 50% 64 The % of sales collected in the month following the sale is 30% 65 The % of sales collected in the second month following the sale is 15% 66 The % of sales that are uncollectible 5% 67 68 4) What are the budgeted Cash collections for the month of May? 69 70 Record your answer, usirty excel formulas, here 71 72 Check the order of your formula calculations 73 For example, if cell al is 15 and cell bl is 4 and cell cl is 2. 74 You want to add cells al and bl and then divide that sum by cell cl Sheet1 Sheet2 Sheet $ 15.00 10 11 BASE DATA: 12 Foundation Data for Solving questions 1, 2 and 3: 13 14 Budgeted Direct Materials Cost Per UNIT 15 16 Budgeted Direct Manufacturing Labor Per UNIT 17 18 Budgeted Manufacturing Overhead Per UNIT 19 20 $ 10.00 $ 5.00 A B D $ 20.00 18,108 Units 20 21 IN ADDITION TO ABOVE USE THE FOLLOWING: 22 23 24 This is Next Year's Budgeted Data for XYZ 25 26 Budgeted Sales Price Per UNIT 27 28 Budgeted Sales - UNITS 29 30 Target Ending Finished Goods Inventory in UNITS 31 32 Target Beginning Finished Goods Inventory in UNITS 33 34 Target Ending Direct Materials Inventory in UNITS 35 36 Target Beginning Direct Materials Inventory in UNITS 37 38 Note: It takes one unit of direct materials to make one production unit. 5,608 Units 4,958 Units 11,608 Units 9,608 Units 0 A B 39 40 WITH THE ABOVE DATA SOLVE THE FOLLOWING QUESTIONS REGARDING YOUR PRODUCT: 41 42 1 How many units should be produced next year? 43 44 Record your answer, using excel formulas, here 45 46 2) What is the dollar amount budgeted for direct material purchased for next year? 47 48 Record your answer, using excel formulas, here 49 50 3) What is the Budgeted Revenues for next year. 51 52 Record your answer, using excel formulas, here 53 54 13,716 21,216 8,716 June 53 54 55 USE ONLY THE FOLLOWING INFORMATION TO ANSWER THIS QUESTION. DO NOT USE ANY INFORMATION FROM ABOVE. 56 57 Gamble Company has the following sales budget for the last six months: 58 January S 16,216 April S 59 February S 18.216 May S 60 March S 10,216 $ 61 62 Historically, the cash collection of sales has been as follows: 63 The % of sales collected in the month of sale is 50% 64 The % of sales collected in the month following the sale is 30% 65 The % of sales collected in the second month following the sale is 15% 66 The % of sales that are uncollectible 5% 67 68 4) What are the budgeted Cash collections for the month of May? 69 70 Record your answer, usirty excel formulas, here 71 72 Check the order of your formula calculations 73 For example, if cell al is 15 and cell bl is 4 and cell cl is 2. 74 You want to add cells al and bl and then divide that sum by cell cl Sheet1 Sheet2 Sheet
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started