Need help, please explain with work if possible. Thank you
etoo Requirement 2 The company has just hired a new marketing manager who insists that unit sales can be dramatically increased by dropping the selling price from s to $7. The marketing manager would like to use the following projections in the budget Y Quarter Year Quarter Data 4 1 Buitent tales 45.00 70,000 115,00 60,000 30.000 90.000 Se price it $7 D F G Deler 1 45.000 2 70.000 3 115.000 4 60,000 Year 3 Quarter 1 80,000 2 20.000 A 1 Chapter 3: Applying Excel 2 3 Data 4 5 Budged units G 7 Single per il 5 Nech, begi balance Sales collected the carries are made 10 les concert Dundin hediyi 12 Trying 13 Raw material required to producer one unit ending water 14 Povestory beginning 5 5 7 per 5.000 75% 2 30% of the budgeted unit sales of the best quarter 17.000 Spounds 198 2000 pound 0.00 chuches are 101 wine purch 10 5 16 Rowman har Aparate for all 5 19 What are the contexpected cash collections for the year under this revised budget What the total required production for the year under the red budget We the cost is to be purchased for the year under the revised budget What are the total expected cash collections for the year under this revised budget? Bethasole b. What is the total required production for the year under this revised budget? What is the total cost of raw materials to be purchased for the year under this revised budget? d Whetsre the total expected cash disbursements for raw materials for the year under this revised budget? Aer seen this revised budget, the production manager cautioned that due to the current production contraint, a complex miling machine the plant can produce ne more than 10.000 units in any one quarter is this a potential problem OY No etoo Requirement 2 The company has just hired a new marketing manager who insists that unit sales can be dramatically increased by dropping the selling price from s to $7. The marketing manager would like to use the following projections in the budget Y Quarter Year Quarter Data 4 1 Buitent tales 45.00 70,000 115,00 60,000 30.000 90.000 Se price it $7 D F G Deler 1 45.000 2 70.000 3 115.000 4 60,000 Year 3 Quarter 1 80,000 2 20.000 A 1 Chapter 3: Applying Excel 2 3 Data 4 5 Budged units G 7 Single per il 5 Nech, begi balance Sales collected the carries are made 10 les concert Dundin hediyi 12 Trying 13 Raw material required to producer one unit ending water 14 Povestory beginning 5 5 7 per 5.000 75% 2 30% of the budgeted unit sales of the best quarter 17.000 Spounds 198 2000 pound 0.00 chuches are 101 wine purch 10 5 16 Rowman har Aparate for all 5 19 What are the contexpected cash collections for the year under this revised budget What the total required production for the year under the red budget We the cost is to be purchased for the year under the revised budget What are the total expected cash collections for the year under this revised budget? Bethasole b. What is the total required production for the year under this revised budget? What is the total cost of raw materials to be purchased for the year under this revised budget? d Whetsre the total expected cash disbursements for raw materials for the year under this revised budget? Aer seen this revised budget, the production manager cautioned that due to the current production contraint, a complex miling machine the plant can produce ne more than 10.000 units in any one quarter is this a potential problem OY No
