2. Geniue Antique Egyptian Artifacts, Inc. produces three varieties of antique artifacts for sale to tourists:...

2. Geniue Antique Egyptian Artifacts, Inc. produces three varieties of antique artifacts for sale to tourists: statuettes, lamps, and urns. All of the artifacts include special clay. A statuette requires 13 ounces of clay, a lamp uses 18 ounces, and each urn takes 17 ounces. Existing capacity of clay is 28,000 ounces per month. A special material is also used to produce the three artifacts, with each statuette needing 0.8 ounces, each lamp 0.7 ounces, and a typical urn requiring 1.0 ounces. The company has inventory of 1,200 ounces of special material per month. The owner of the company wishes to maintain a balanced marketing program, and has ordered that production of statuettes to be limited to 275. The overall per unit profit for artifacts is the following: $199 per statuette, $99 per lamp, and $145 per urn. The owner wants to know how much of each type of antique to fabricate monthly in order to optimize profit.

a. What are the objective function, decision variables, and constraints for this optimization problem?

b. Develop an Excel spreadsheet and use Excel-Solver to find an optimal solution for this problem.

c. Describe the optimal solution in words.

Solutions

Expert Solution

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

Egyptian Spa produces two different spa products: Relax and Refresh. The company uses three operations to...

Egyptian Spa produces two different spa products: Relax and Refresh. The company uses three operations to manufacture the detergents: mixing, blending, and packaging. Because of the materials used, Relax is produced in powder form in the mixing department and then transferred to the blending department and then onto packaging. Refresh is produced in liquid form in the blending department and is then transferred to packaging. Egyptian Spa applies conversion costs based on laborhours in the mixing department. It takes 3...

Egyptian Spa produces two different spa products: Relax and Refresh. The company uses three operations to...

Egyptian Spa produces two different spa products: Relax and Refresh. The company uses three operations to manufacture the products: mixing, blending, and packaging. Because of the materials used, Relax is produced in powder form in the mixing department, then transferred to the blending department, and finally on to packaging. Refresh undergoes no mixing; it is produced in liquid form in the blending department and then transferred to packaging. Egyptian Spa applies conversion costs based on labor-hours in the mixing department....

2. Past Perfect Inc. is a small firm that sells antique furnishings. In the most recent...

2. Past Perfect Inc. is a small firm that sells antique furnishings. In the most recent year, the firm generated $ 4 million in after-tax operating income on revenues of $ 40 million; the firm reported book value of equity of $ 8 million and book value of debt of $ 4 million at the beginning of the year. During the year, the firm invested $2 million in a new warehouse for furniture (its only cap ex) and reported depreciation...

2. Cholati is a foreign corporation that produces fine chocolates for sale worldwide. Cholati markets it...

2. Cholati is a foreign corporation that produces fine chocolates for sale worldwide. Cholati markets it chocolates in the United States through a U.S. limited liability company that is treated as a disregarded entity for U.S. tax purposes. The hybrid branch operates a sales office located in New York City. During the current year, Cholati’s effectively connected earnings and profits are $3 million, and its U.S. net equity is $6 million at the beginning of the year, and $4 million...

Product Mix for TJ, Inc. TJ's, Inc., makes three nut mixes for sale to grocery chains...

Product Mix for TJ, Inc. TJ's, Inc., makes three nut mixes for sale to grocery chains located in the Southeast. The three mixes, referred to as the Regular Mix, the Deluxe Mix, and the Holiday Mix, are made by mixing different percentages of five types of nuts. In preparation for the fall season, TJ's purchased the following shipments of nuts at the prices shown: Type of Nut Shipment Amount (pounds) Cost per Shipment Almond 6000 $7500 Brazil 7500 $7125 Filbert...

Star Videos, Inc., produces short musical videos for sale to retail outlets. The company's balance sheet...

Star Videos, Inc., produces short musical videos for sale to retail outlets. The company’s balance sheet accounts as of January 1 are given below. Star Videos, Inc.Balance SheetJanuary 1AssetsCash$87,000Accounts receivable107,200Inventories:Raw materials (film, costumes)$15,800Videos in process54,600Finished videos awaiting sale94,400164,800Prepaid insurance11,150Studio and equipment (net)582,000Total assets$952,550Liabilities and Stockholders’ EquityAccounts payable$231,000Retained earnings721,550Total liabilities and stockholders’ equity$952,550 Because the videos differ in length and in complexity of production, the company uses a job-order costing system to determine the cost of each video produced. Studio (manufacturing) overhead is...

Star Videos, Inc., produces short musical videos for sale to retail outlets. The company's balance sheet...

Star Videos, Inc., produces short musical videos for sale to retail outlets. The company’s balance sheet accounts as of January 1 are given below. Star Videos, Inc.Balance SheetJanuary 1AssetsCash$82,600Accounts receivable97,600Inventories:Raw materials (film, costumes)$42,800Videos in process56,600Finished videos awaiting sale79,800179,200Prepaid insurance10,050Studio and equipment (net)548,000Total assets$917,450Liabilities and Stockholders’ EquityAccounts payable$188,000Retained earnings729,450Total liabilities and stockholders’ equity$917,450 Because the videos differ in length and in complexity of production, the company uses a job-order costing system to determine the cost of each video produced. Studio (manufacturing) overhead is...

Star Videos, Inc., produces short musical videos for sale to retail outlets. The company’s balance sheet...

Star Videos, Inc., produces short musical videos for sale to retail outlets. The company’s balance sheet accounts as of January 1 are given below. Star Videos, Inc. Balance Sheet January 1 Assets Cash $ 89,200 Accounts receivable 106,600 Inventories: Raw materials (film, costumes) $ 13,400 Videos in process 47,400 Finished videos awaiting sale 80,400 141,200 Prepaid insurance 8,350 Studio and equipment (net) 610,000 Total assets $ 955,350 Liabilities and Stockholders’ Equity Accounts payable $ 238,000 Retained earnings 717,350 Total liabilities...

Star Videos, Inc., produces short musical videos for sale to retail outlets. The company’s balance sheet...

Star Videos, Inc., produces short musical videos for sale to retail outlets. The company’s balance sheet accounts as of January 1 are given below. Star Videos, Inc. Balance Sheet January 1 Assets Cash $ 88,000 Accounts receivable 114,600 Inventories: Raw materials (film, costumes) $ 20,000 Videos in process 51,800 Finished videos awaiting sale 97,200 169,000 Prepaid insurance 10,750 Studio and equipment (net) 598,000 Total assets $ 980,350 Liabilities and Stockholders’ Equity Accounts payable $ 189,000 Retained earnings 791,350 Total liabilities...

Subjects