(Solved by Humans)-Problem 5-31A Allocating scarce resourcesem

Paper Details

Problem 5-31A Allocating scarce resourcesThe following information applies to the products of Zoghbi Company.  Product AProduct BSelling price per unit$26$24Variable cost per unit2218 Spreadsheet Assignment Mastering ExcelRefer to Problem 5-31A.Requireda. 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.)Requireda. 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?