History Bookmarks Profiles DI Apartme x AAC 221.docx 2 C ure.com/courses/96752/assignments/1049647 W S X command Week 4 A #3 E X Excel Project #2 D Facts: Projected Sales: Jan Tab Window Help Cengage X $ 4 1,100 units at $10 per unit 1,150 units at $10 per unit Feb March 1,200 units at $10 per unit 1,150 units at $10 per unit April May 1,100 units at $10 per unit Finished Goods Inventory: Delieve C Dallas Company is preparing a master budget for the 1st quarter of 2023. Given the following information, you are to prepare in Excel using formulas the following: (A) Production Budget, (B) Direct Materials Budget, and (C) Cash Payments for Direct Materials Purchases Budget for the 1st quarter of 2023. For the budgets, you need to make them adaptable so that if I change the sales budget and/or materials cost per unit, the budgets will automatically update for these changes (for a 9 or better score). For a score of 8 or better, I need to see the months of January, February, March, and the Quarter total. JUL 22 R