Please include your clear solutions using Ms excel (excel format). Kindly read the instructions in the picture below. Thank you?

INSTRUCTIONS: KINDLY INCLUDE YOUR CLEAR SOLUTIONS IN EACH QUESTION USING MS EXCEL AND UPLOAD LINK IF ITS OKAY. BUT IF NOT, YOU CAN SEND YOUR EXCEL SCREENSHOT. THANK YOU 16. Assuming that Simmons increased sales of Product A by 25 percent, what should the profit from Product A be? Information concerning Simmons Corporation's Product A follows: Sales $400, 000 Variable costs 300, 000 Fixed costs 50, 000 a. $ 50,000 b. $ 62,500 c. $ 75,000 d. $170,00017. Refer to Kenwood Electronics Corporation. The Model B2 radio is currently in production and it renders the Model A1 radio obsolete. If the remaining 500 units of the Model A1 radio are to be sold through regular channels, what is the minimum price the company would accept for the radios? Kenwood Electronics Corporation Kenwood Electronics Corporation manufactures and sells FM radios. Information on the prior year's operations (sales and production Model Al) is presented below: Sales price per unit $30 Costs per unit: Direct material 7 Direct labor Overhead (50% variable) Selling costs (40% variable) 10 Production in units 10, 000 Sales in units 9, 500 a. $30 b. $27 c. $18 d. $4 18. Refer to Kenwood Electronics Corporation. Assume that the remaining Model A1 radios can be sold through normal channels or to a foreign buyer for $6 per unit. If sold through regular channels, the minimum acceptable price will be a. $30. b. $33. c. $10. d. $4.19. Refer to Memory Division of Missing Byte, Inc. Assume, for this question only, that the Memory Division is producing and selling at capacity. What is the minimum selling price that the division would consider on a "special order" of 1,000 chips on which no variable period costs would be incurred? Memory Division of Missing Byte, Inc. The Memory Division of Missing Byte, Inc. produces a high-quality computer chip. Unit production costs (based on capacity production of 100,000 units per year) follow: Direct material $50 Direct labor 20 Overhead (20% variable) 10 Other information: Sales price 100 SG&A costs (40% variable) 15 a. $100 b. $72 c. $81 d. $94 20. Refer to Memory Division of Missing Byte, Inc. Assume, for this question only, that the Memory Division is operating at a level of 70,000 chips per year. What is the minimum price that the division would consider on a "special order" of 1,000 chips to be distributed through normal channels? a. $78 b. $95 c. $100 d. $81 21. Refer to Memory Division of Missing Byte, Inc. Assume, for this question only, that the Memory Division is presently operating at a level of 80,000 chips per year. Accepting a "special order" on 2,000 chips at $88 will a. increase total corporate profits by $4,000. b. increase total corporate profits by $20,000. c. decrease total corporate profits by $14,000. d. decrease total corporate profits by $24,000.22. Refer to Galveston Pipe Corporation. The major opportunity cost associated with the continued use of the existing machine is Galveston Pipe Corporation The capital budgeting committee of the Galveston Pipe Corporation is evaluating the possibility of replacing its old pipe-bending machine with a more advanced model. Information on the existing machine and the new model follows: Existing machine New machine Original cost $200, 000 $400, 000 Market value now 80, 000 Market value in year 5 20, 000 Annual cash operating costs 40, 000 10, 000 Remaining life 5 yrs. 5 yrs. a. $30,000 of annual savings in operating costs. b. $20,000 of salvage in 5 years on the new machine. c. lost sales resulting from the inefficient existing machine. d. $400,000 cost of the new machine. 23. Refer to Galveston Pipe Corporation. The $80,000 market value of the existing machine is a. a sunk cost. b. an opportunity cost of selling the old machine. c. irrelevant to the equipment replacement decision. d. a historical cost. 24. Refer to Galveston Pipe Corporation. If the company buys the new machine and disposes of the existing machine, corporate profit over the five-year life of the new machine will be than the profit that would have been generated had the existing machine been retained for five years. a. $150,000 lower b. $170,000 lower c. $230,000 lower d. $150,000 higher