Problem -
Master budget for the year 2019 for Much Better (MBP) Products, Inc. Prepare the following budgets:
Sales Budget
Production Budget
Direct Materials Purchases Budget
Direct Labor Budget
Manufacturing Overhead Budget
Selling and Administrative Expense Budget
Cost of Goods Manufactured Budget
Budgeted Income Statement
These budgets should be linked so that you can change estimated sales units on the Sales Budget that results in corresponding changes in budgeted net income without making other changes to the budgets. Save these budgets in a file entitled "YourLastNameMBPMB1."
B. After completing the MB1, increase the budgeted sales in units by 5% on the Sales Budget for each quarter of year 2019. Do not change any quantities or other information related to year 2018 or 2020. After entering the new sales estimates in the spreadsheet prepared above, save this information in a file entitled "YourLastNameMBPMB2."
C. After completing the MB2 above, increase the budgeted sales from MB1 in units by 10% for each quarter of year 2019. Do not change any quantities or other information related to year 2018 or 2020. After entering the new sales estimates in the spreadsheet prepared above, save this information in a file entitled "YourLastNameMBPMB3.
Need correct solution in excel with explanation in words.
Attachment:- Assignment Files.rar