Spreadsheet Assignment Mastering Excel Refer to Problem 5-31A.

Required

a. Prepare a spreadsheet to solve Requirements

a, b, and c in Problem 5-31A.

b. While constructing formulas for Requirement a of Problem 5-31A, include a formula to calculate contribution margin per labor hour.

c. While constructing formulas for Requirement b of Problem 5-31A, include formulas to calculate total contribution margin for each product.

d. While constructing formulas for Requirement c of Problem 5-31A, include formulas to calculate contribution margin per machine hour and total contribution margin for each product.

Use the same transaction data for Magnificent Modems, Inc., as was used in Chapter 1. (See page 52.)
Required

a. One of Magnificent Modems’ sales representatives receives a special offer to sell 1,000 modems at a price of $72 each. Should the offer be accepted?

b. Magnificent Modems has the opportunity to purchase the modems that it currently makes. The modems can be purchased at a price of $76 each. Assuming the manufacturing equipment has a zero market value, should Magnificent buy the modems?

c. Assume that Magnificent Modems expects production and sales to grow to 10,000. At this volume of production, should Magnificent buy the modems?