Please solve each problem using excel solver tool and show the equations.

Table B Standard Product Costs a. See Table C Table C Overhead Budget for 1988 a. Based on a moothly production rate of 1,000 Model 101 trucis asd 1,500 Model 102 trucles. b. Foed overhead was distributed to the two truck models in proportion to degroe of capacity utilization. Merton Truck Problem 1 Sales P Costs: Answer questions 1(a-d) below: 1. (a) Find the best product mix for Merton. (b) What would be the best product mix if engine assembly capacity were raised by one unit, from 4,000 to 4,001 machine-hours? What is the extra unit of capacity worth? (c) Assume that a second additional unit of engine assembly capacity is worth the same as the first. Verify that if the capacity were increased to 4,100 machinehours, then the increase in contribution would be 100 times that in part (b). (d) How many units of engine assembly capacity can be added before there is a change in the value of an additional unit of capacity? Table B Standard Product Costs a. See Table C Table C Overhead Budget for 1988 a. Based on a moothly production rate of 1,000 Model 101 trucis asd 1,500 Model 102 trucles. b. Foed overhead was distributed to the two truck models in proportion to degroe of capacity utilization. Merton Truck Problem 1 Sales P Costs: Answer questions 1(a-d) below: 1. (a) Find the best product mix for Merton. (b) What would be the best product mix if engine assembly capacity were raised by one unit, from 4,000 to 4,001 machine-hours? What is the extra unit of capacity worth? (c) Assume that a second additional unit of engine assembly capacity is worth the same as the first. Verify that if the capacity were increased to 4,100 machinehours, then the increase in contribution would be 100 times that in part (b). (d) How many units of engine assembly capacity can be added before there is a change in the value of an additional unit of capacity