XYZ Corporation manufactures two products, Simple and Complex. The following annual information was gathered: Simple Complex Selling price per unit P47.00 P26.00 Variable cost per unit 42.00 22.00 Total annual fixed costs are P18,000. Assume XYZ Corporation can produce and sell any mix of Simple or Complex at full capacity. It takes 1.5 hours to make one unit of Complex. However, Simple takes 50% longer to manufacture when compared to Complex. Only 120,000 hours of plant capacity are available. How many units of Simple and Complex should XYZ Corporation produce and sell in a year to maximize profits?

XYZ Corporation manufactures two products, Simple and Complex. The following annual information was gathered: Simple Complex Selling price per unit P47.00 P26.00 Variable cost per unit 42.00 22.00 Total annual fixed costs are P18,000. Assume XYZ Corporation can produce and sell any mix of Simple or Complex at full capacity. It takes 1.5 hours to make one unit of Complex. However, Simple takes 50% longer to manufacture when compared to Complex. Only 120,000 hours of plant capacity are available. How many units of Simple and Complex should XYZ Corporation produce and sell in a year to maximize profits?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...

See similar textbooks

Similar questions

The Tinkan Company produces one-pound cans for the Canadian salmon industry. Each year the salmon spawn during a 24-hour period and must be canned immediately. Tinkan has the following agreement with the salmon industry. The company can deliver as many cans as it chooses. Then the salmon are caught. For each can by which Tinkan falls short of the salmon industrys needs, the company pays the industry a 2 penalty. Cans cost Tinkan 1 to produce and are sold by Tinkan for 2 per can. If any cans are left over, they are returned to Tinkan and the company reimburses the industry 2 for each extra can. These extra cans are put in storage for next year. Each year a can is held in storage, a carrying cost equal to 20% of the cans production cost is incurred. It is well known that the number of salmon harvested during a year is strongly related to the number of salmon harvested the previous year. In fact, using past data, Tinkan estimates that the harvest size in year t, Ht (measured in the number of cans required), is related to the harvest size in the previous year, Ht1, by the equation Ht = Ht1et where et is normally distributed with mean 1.02 and standard deviation 0.10. Tinkan plans to use the following production strategy. For some value of x, it produces enough cans at the beginning of year t to bring its inventory up to x+Ht, where Ht is the predicted harvest size in year t. Then it delivers these cans to the salmon industry. For example, if it uses x = 100,000, the predicted harvest size is 500,000 cans, and 80,000 cans are already in inventory, then Tinkan produces and delivers 520,000 cans. Given that the harvest size for the previous year was 550,000 cans, use simulation to help Tinkan develop a production strategy that maximizes its expected profit over the next 20 years. Assume that the company begins year 1 with an initial inventory of 300,000 cans.
It costs a pharmaceutical company 75,000 to produce a 1000-pound batch of a drug. The average yield from a batch is unknown but the best case is 90% yield (that is, 900 pounds of good drug will be produced), the most likely case is 85% yield, and the worst case is 70% yield. The annual demand for the drug is unknown, with the best case being 20,000 pounds, the most likely case 17,500 pounds, and the worst case 10,000 pounds. The drug sells for 125 per pound and leftover amounts of the drug can be sold for 30 per pound. To maximize annual expected profit, how many batches of the drug should the company produce? You can assume that it will produce the batches only once, before demand for the drug is known.
XYZ Corporation manufactures two products, Simple and Complex. The following annual information was gathered: Simple Complex Selling price per unit P47.00 P26.00 Variable cost per unit 42.00 22.00 Total annual fixed costs are P18,000. Assume XYZ Corporation can produce and sell any mix of Simple or Complex at full capacity. It takes one hour to make one unit of Complex. However, Simple takes 50% longer to manufacture when compared to Complex. Only 120,000 hours of plant capacity are available. How many units of Simple and Complex should XYZ Corporation produce and sell in a year to maximize profits?
The Chineke Group of Company manufactures two products, namely product B and product P, and provides you with the following information: Prod. B Prod. P Selling price per unit 80.00 50.00 Less cost of sales: Direct material A @ R5.00 per kg 15.00 10.00 Direct material B @ R4.00 per kg 8.00 12.00 Direct labour @ R6.00 per hour 12.00 6.00 Variable manufacturing overhead @ R5.00 per labour hour 10.00 5.00 Fixed manufacturing overhead per unit 5.00 5.00 Gross profit 30.00 12.00 Less sales & administrative costs: Variable 6.00 4.00 Fixed 10.00 5.00 Net profit per unit 14.00 3.00 Take note of the following constraints: Material A available 360 kg Material B available 360 kg Labour hours available…
Dana’s Ribbon World makes award rosettes. Following is information about the company: Variable cost per rosette $ 2.00 Sales price per rosette $ 6.00 Total fixed costs per month $ 6000.00 Required: 1. Suppose Dana’s would like to generate a profit of $1,120. Determine how many rosettes it must sell to achieve this target profit. 2. If Dana’s sells 2,140 rosettes, compute its margin of safety in units, in sales dollars, and as a percentage of sales. 3. Calculate Dana’s degree of operating leverage if it sells 2,140 rosettes. 4a. Using the degree of operating leverage, calculate the change in Dana’s profit if unit sales drop to 1,819 units. 4b. Prepare a new contribution margin income statement to verify change in dana's profit.
Box Electric makes electronic components and has estimated the following for a new design of one of its products. Fixed cost = $24,975 Material cost per unit = $0.17 Labor cost per unit = $0.12 Revenue per unit = $0.66 Note that fixed cost is incurred regardless of the amount produced. Per-unit material and labor cost together make up the variable cost per unit. Assuming that Box Electric sells all that it produces, profit is calculated by subtracting the fixed cost and total variable cost from total revenue. Construct an appropriate spreadsheet model to find the profit based on a given production level and use the spreadsheet model to answer these questions. (a) Construct a one-way data table with production volume as the column input and profit as the output. Breakeven occurs when profit goes from a negative to a positive value; that is, breakeven is when total revenue = the total cost, yielding a profit of zero. Vary production volume from 0 to 100,000 in increments of 10,000.…
Telsla produces a range of electric car models. The following presents hypothetical information in regards to the production of these cars. The production manager would like your assistance to identify the optimal production mix. Below is an estimation of the costs to manufacture these products. Model S Model 3 Model X Selling price $130,000.00 $63,000.00 $150,000.00 Direct materials $60,000.00 $26,000.00 $67,000.00 Direct labour $17,500.00 $11,500.00 $20,750.00 Variable overhead $13,125.00 $8,625.00 $15,562.50 Fixed overhead $8,750.00 $5,750.00 $10,375.00 Each of these products goes through the same manufacturing process. The time for each process required for each model and the total hours available for each process are provided in the table below. Process Model S Model 3 Model X Total hours available Body 2 1.5 2.5 750,000 Stamping 1 0.75 1.2 400,000 Plastics 2 1.75 2.1 700,000 Assembly 4 3.5 4.5 1,400,000 Required: Using Excel…
Triple X Company manufactures and sells refrigerators. It makes some of the parts for the refrigerators and purchases others. The engineering department believes it might be possible to cut costs by manufacturing one of the parts currently being purchased for $8.25 each. The fi rm uses 100,000 of these parts each year. The accounting department compiles the following list of costs based on engineering estimates:Fixed costs will increase by $50,000. Labor costs will increase by $125,000.Factory overhead, currently running $500,000 per year, may be expected to increase 12 percent.Raw materials used to make the part will cost $600,000.Given the preceding estimates, should Triple X make the part or continue to buy it?
An electronics firm is currently manufacturing anitem that has a variable cost of $.50 per unit and a selling priceof $1.00 per unit. Fixed costs are $14,000. Current volume is 30,000 units. The firm can substantially improve the productquality by adding a new piece of equipment at an additional fixedcost of $6,000. Variable cost would increase to $.60, but volumeshould jump to 50,000 units due to a higher-quality product.Should the company buy the new equipment?
Fitness Express sells three different types of elliptical machines. They have manufactured 50 of each machine for a special sale. The store already ha orders for 46 of machine A and 16 of machine B. Use the following information to determine how many of machine C the store needs to sell to break even? Show your work on a separate sheet of paper. Manufacturing Cost $105.00 $140.00 $175.00 Elliptical Machine Machine A Machine B Machine C Total costs of all machines: $ Total revenue: $ Number of machine Cs to sell to break even: Retail Cost $250.00 $305.00 $420.00
I need a detailed explanation and assistance to solve this problem: Wineco produces wine cooler as a blend of wine, grape juice and apple juice ingredients, which it sells for $4 per gallon. The costs of ingredients are given in the following table: Cooler Ingredient Price per Gallon ($) wines 1.20 grape juice 1.40 Apple juice 0.60 Wineco owns a blending plant with a production capacity of 200 gallons per day. Because the plant is fully automated, all other production costs are negligible by comparison to the cost of ingredients, and can be ignored. Government regulations mandate that wine cooler products must satisfy the following guidelines: At least 10% of the blend produced must be grape juice. The ratio of apple juice to grape juice in the blend produced must be 2.5:1 The blend produced must contain between 20% and 25% wine. Wineco wishes to use LP in order to determine the quantities of ingredients to buy for a day’s production of wine cooler, so…
Western Chassis produces high-quality polished steel and aluminum sheeting and two lines of industrial chassis for the rack mounting of Internet routers, modems, and other telecommunications equipment. The contribution margin (contribution toward profit) for steel sheeting is $0.40 per pound and for aluminum sheeting is $0.60 per pound. Western earns $12 contribution on the sale of a Standard chassis rack and $15 contribution on a Deluxe chassis rack. During the next production cycle, Western can buy and use up to 25,800 pounds of raw unfinished steel either in sheeting or in chassis. Similarly, 20,400 pounds of aluminum are available. One standard chassis rack requires 16 pounds of steel and 8 pounds of aluminum. A Deluxe chassis rack requires 12 pounds of each metal. The output of metal sheeting is restricted only by the capacity of the polisher. For the next production cycle, the polisher can handle any mix of the two metals up to 4,000 pounds of metal sheeting. Chassis manufacture…