please post in excel with formulas to fill the first sheet if possible. thank you so much!

The Excel worksheet form that appears below is to be used to recreate the Review Problem related to Mynor Corporation. The workbook, and instructions on how to complete the file can be found in Connect. Page 381 D H Chapter 8: Applying Excel 2 1. Data 1 10 000 Year 2 Quarter 2 3 50 000 100 000 Year 3 Quarter 1 2 70 000 80,000 50.000 5. Budgeted 6 7. Selling priceperunt Accounce beginning balance 9. Ses colected in the quarter sales are made 10 Selected in the quarter sales are made 11.Dured ending the goods inventory is 13 Fushed goodstory, baging 13 Raw mas produce net 14.Derdining room 15. Rannvertory bagong 16. Rawat 11. Purchad and 19 Accounts payable for beginning balance 21 Ewa fomuch of them with 22 Review Problem Budget Schedule 2 24 Conches 565000 76 25% 30% of the budged unters of the next 12.000 6 pounds 10% of the quarter's production needs 23 000 pound 50 80 per pound 60% in the quarter the purchases we made 40% in the quarterlowing purchase 301.500 5 www.tw Your 77 Slingrepet 30 Tuis Year Our We 10 Constructie hede of expected the collection 13 enese Second 15. Thus 12 Yew 1 4 Year 7 7 ? 2 7 ? Year 2 Quarter 2 3 ? 7 ? 7 ? ? 2 ? 7 ? ? 2 ? 2 7 7 7 ? 2 ? Year 3 Quarter 1 2 ? ? ? ? 7 1 4 39 Construct the production budget 40 41 Budgeted unit sales 42 Add desired ending finished goods inventory 43 Total needs 44 Less beginning finished goods inventory 45 Required production in units 46 47 Construct the raw materials purchases budget 48 49 Required production (unit) 50 Raw materials required to produce one unit (pounde) 51 Production needs (pounds) 52 Add desired ending Inventory of raw materials (pounds) 53 Total needs (pounds) 54 Less beginning inventory of raw materials (pounds) 55 Raw materials to be purchased (pounds) 56 Cost of raw materials per pound 57 Cout of raw matenals to be purchased 55 59 Construct the schedule of expected cash payments 60 61 Beginning balance accounts payable 62 First quarter purchases 63 Second quarter purchases 04 Third quarter purchases 65 Fourth quarter purchase 66 Total cash disbursements 67 # Chapter Form dedinu Chapter 2 7 ? 2 ? 2 ? 2 ? Year 2 Quarter 2 3 ? 7 2 2 2 ? ? 2 2 2 ? ? 2 2 2 2 7 7 ? 2 2 2 ? 2 7 2 ? Year 3 Quarter Year 1 2 ? ? 2 2 ? ? 7 2 ? 2 2 Year 2 Quarter 2 3 Year 7 2 2 2 2 2 2 Cute Required: 1. 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. The required production for the year should bc 274,000 units. The cost of raw materials to be purchased for the year should be $1.106,800, whereas the total cash disbursements for the year should be $1,095,980. In you do not get these answers, find the errors in your worksheet and correct them. Why have the total cash disbursements for raw materials increased? 2. The company has just hired a new marketing manager who insists that unit sules can be dramatically increased by dropping the selling price from $8 to $7. The marketing manager would like to use the following projections in the budget: Year 2 Quarter Year 3 Quarter 1 2 3 1 2 Budgeted unit sales 50.000 70,000 120.000 80,000 90.000 100.000 Selling price per unit $7 a. What are the total expected cash collections for the year under this revised budget? . What is the total required production for the year under this revised budget? 10. What is the total cost of raw materials to be purchased for the year under this revised budget? d. What are the total expected cash disbursements for raw materials for the year under this revised budget? c. After seeing this revised budget, the production manager cautioned that due to the limited availability of a complex milling machine the plant can produce no more than 90.000 units in any one quarter Is this a potential problem? If so, what can be done about it