SHOW WORK IN EXCEL

The Bundy Shoe Emporium reports the following on December 31 st 2022 Sales volume 63360 units Sales Revenue $823,680.00 Variable Costs Fixed Costs Operating profit $120,100.00 13 14 15 The Bundy Shoe Emporium planned on producing and selling 72000 pairs of shoes at $12.50 each 16 At that volume contribution margin would have been $648000 Variable marketing is budgeted at 5% of sales volume 18 fixed manufacturing is budgeted at $5 per pair of shoes with a volumne of 72000 pairs of shoes. 19 Managements budgets $2.50 per pair operating profit at 72000 unit sales volume REQUIRED: A) construct a master budget B) prepare a profit variance analysis