please provide answer in excel speadsheet

a) construct a master budget

b) prepare a profit variance analysis

The Bundy Shoe Emporium reports the following on December 31 st 2022 The Bundy Shoe Emporium planned on producing and selling 72000 pairs of shoes at $12.50 each At that volume contribution margin would have been $648000 Variable marketing is budgeted at 5% of sales volume fixed manufacturing is budgeted at $5 per pair of shoes with a volumne of 72000 pairs of shoes. 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 The Bundy Shoe Emporium reports the following on December 31 st 2022 The Bundy Shoe Emporium planned on producing and selling 72000 pairs of shoes at $12.50 each At that volume contribution margin would have been $648000 Variable marketing is budgeted at 5% of sales volume fixed manufacturing is budgeted at $5 per pair of shoes with a volumne of 72000 pairs of shoes. 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