A manufacturer produces three models (I, II, and II) of a certain product using raw materials A and B. The labor time per unit model of I is twice that of Il and three times that of III. The entire labor force of the factory can produce the equivalent of 1500 units of Model I. Market requirements specify the ratios 3:2:5 for the production of the three respective models and minimum demand levels should be satisfied. Requirement Raw Material II Availability A 2 3 4000 B 4 2 7 6000 Minimum demand 200 200 150 Price per unit 30 20 50

A manufacturer produces three models (I, II, and II) of a certain product using raw materials A and B. The labor time per unit model of I is twice that of Il and three times that of III. The entire labor force of the factory can produce the equivalent of 1500 units of Model I. Market requirements specify the ratios 3:2:5 for the production of the three respective models and minimum demand levels should be satisfied. Requirement Raw Material II Availability A 2 3 4000 B 4 2 7 6000 Minimum demand 200 200 150 Price per unit 30 20 50

Name: A manufacturer produces three models (I, II, and III) of a certain pr
Uploaded: 2024-03-20T06:57:05.000Z
Channel: Bartleby
Description: A manufacturer produces three models (I, II, and III) of a certain product using raw materials A and B. The labortime per unit model of I is twice that of Il and three times that of III. The entire labor force of the factory canproduce the equivalen

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

ProHaul specializes in trans-American shipments for businesses through the delivery of containers. For every container the company loads on its trucks, ProHaul estimates the haul costs $1,000. In addition, containers are weighed and for each pound, there are hauling fees of $0.15. ProHaul plans to charge $0.49 per pound to his customers.Break even=2,941.17647 unitsWhat would the total revenue be for this?
Production and Materials Purchases Budgets White Corporation’s budget calls for the following sales for next year:Quarter 1 90,000 units Quarter 3 68,000 unitsQuarter 2 76,000 units Quarter 4 96,000 unitsEach unit of the product requires 3 pounds of direct materials. The company’s policy is to begineach quarter with an inventory of product equal to 5% of that quarter’s estimated sales requirementsand an inventory of direct materials equal to 20% of that quarter’s estimated direct materials requirements for production.Required Determine the production and materials purchases budgets for the second quarter.
ProHaul specializes in trans-American shipments for businesses through the delivery of containers. For every container the company loads on its trucks, ProHaul estimates the haul costs $1,000. In addition, containers are weighed and for each pound, there are hauling fees of $0.15. ProHaul plans to charge $0.49 per pound to his customers.a. How many pounds would a container have to hold in order for the company to Break Even?b. What would the total revenue be for this?c. The company finds out that to maintain the integrity of its containers, each container could only hold an average of 8,000 pounds. What would the company have to charge customers to make $5,000 in profit on each container?
Francesca’s Boutique has a merchandise budget that includes $53,420 in planned sales for Dresses, $5342 in planned reductions, and $63,762 in planned purchases. The assortment includes 4 sub classifications (Casual (30%), dressy (20%), day-to-night (35%), date night (15%)) with 5styles, 4 colors, 4 sizes (for each sub class). The average first price on the dress is $45. Francesca’s expects to devote about 50 square feet to displaying the dresses in each store (10 stores), and the shirts to generate approx. $107 per square foot during the fall selling period. Markdowns are expected to be 10% of sales. Average Markup is 63%. Based on the information provided: What is the planned volume of the assortment? (Note: Use Planned Merchandise to Receive figures) How many SKUs are in this assortment? What is the model stock for the entire dress assortment?
Max the Tailor is going to sell custom suits. He was able to rent a garage from his Uncle Ed for $2,000 a month, which includes utilities, and he already owns the equipment he needs. He anticipates being able to sell his suits for $500 each. The raw materials (fabric, buttons, zippers, thread, etc.) will cost an average of $75 for each suit, and he plans to spend $25 per suit to advertise them. Assuming these are all the costs and revenues, what will be Max’s monthly break-even point in units? Does this seem like a reasonable amount for him to produce and sell every month? Please show your calculations.
Auria will produce 3 vehicle components and knows that each start generates a cost of 5,000 pesos. The cost of the units is $ 200, $ 100 and $ 70 respectively. Annual demand is 100,000 units for Product A, 150,000 units for Product B, and 200,000 units for Product C. The inventory rate is 15% per month. Product A and B are basic and substitutable products, so there must be a minimum average inventory of 8,000 units of both. The company seeks a maximum of $ 100,000 invested money in inventory. The available warehouse space is 400m3 and product A occupies 0.5m3, product B 0.7m3 and C 1m3. Consider that product A and C allow shortages and the goodwill loss cost is $ 3 for each unit of those items. a) Formulate the problem as a mathematical programming model (objective function and constraints) that minimizes the total annual cost
Williams Inc. produces fluorescent lightbulbs for commercial use. The accounting manager isattempting to estimate the total cost for the next quarter using the high-low method. He has compileddata and found the high and low costs are $10,000 and $6,000, respectively, and the associated costdrivers are 7,000 and 3,000 packs, respectively. What is the value for b (the variable cost per unit)?What is the value for a (the fixed quantity)?
M&L Manufacturing makes various components for printers andcopiers. In addition to supplying these items to a major manufacturer,the company distributes these and similar items to officesupply stores and computer stores as replacement parts forprinters and desktop copiers. In all, the company makes about20 different items. The two markets (the major manufacturerand the replacement market) require somewhat different handling.For example, replacement products must be packagedindividually whereas products are shipped in bulk to the majormanufacturer.The company does not use forecasts for production planning.Instead, the operations manager decides which items to produceand the batch size, based on orders and the amounts in inventory.The products that have the fewest amounts in inventory get thehighest priority. Demand is uneven, and the company has experiencedbeing overstocked on some items and out of others. Beingunderstocked has occasionally created tensions with the managersof…
M&L Manufacturing makes various components for printers andcopiers. In addition to supplying these items to a major manufacturer,the company distributes these and similar items to officesupply stores and computer stores as replacement parts forprinters and desktop copiers. In all, the company makes about20 different items. The two markets (the major manufacturerand the replacement market) require somewhat different handling.For example, replacement products must be packagedindividually whereas products are shipped in bulk to the majormanufacturer.The company does not use forecasts for production planning.Instead, the operations manager decides which items to produceand the batch size, based on orders and the amounts in inventory.The products that have the fewest amounts in inventory get thehighest priority. Demand is uneven, and the company has experiencedbeing overstocked on some items and out of others. Beingunderstocked has occasionally created tensions with the managersof…
Trinity product Limited makes and sells three types of electronic security systems for which the following information is available Standard cost and selling price per unitDay Scan Night scan Omni scan GH¢ GH¢ GH¢Material 70 110 155Manufacturing labour. 40 55 70Installation labour. 24 32 44Variable overheads. 16 20 28Selling price 250 320 460 Fixed cost for the period are GH¢450,000 and installation labour, which is highly skilled is available for 25,000 hours only in a period and is paid GH¢8 per hour. Both manufacturing and installation labour are variable cost. The maximum demand for the period is: Day scan 2,000 units; Night scan 3,000 units; Omni scan 1,800 units. RequiredA) Having carried out an investigation of the availability of installation labour, the firm thinks that by offering GHS 12 per hour, additional installation would become available and thus overcome the labour…
All-Natural Coop makes three breakfast ccrcals, A, B, and C, from four ingredients: rolled oats, raisins, shredded coconuts, and slivered almonds. The daily availabilities of the ingredients are 5 tons, 2 tons, 1 ton, and 1 ton, respectively. The corresponding costs per ton are $100, $120, $110, and $200, respectively. Cereal A is a 50:5:2 mix of oats, raisins, and almond. Cercal B is a 60:2:3 mix of oats, coconut, and almond. Cercal C is a 60:3:4:2 mix of oats, raisins, coconul, and almond. The cercals are prodluced in jumbo 5-lb sizes. All-Natural sells A, B, and Cat $2.00, $2.50, and $3.00 per box, respectively. The minimum daily demand for cereals A. B, and C is 500, 600, and 500 boxes, respectively. Develop an LP model to determine the optimal production mix of the cereals and the associated amounts of ingredients, and find the solution using execl Solver
Problem 21-9 (Algo) Semans is a manufacturer that produces bracket assemblies. Demand for bracket assemblies (X) is 137 units. The following is the BoM in indented form: ITEM DESCRIPTION USAGE X Bracket assembly 1 A Wall board 5 B Hanger subassembly 2 D Hanger casting 2 E Ceramic knob 1 C Rivet head screw 4 F Metal tong 3 G Plastic cap 1 Below is a table indicating current inventory levels: Item X A B C D E F G Inventory 30 20 73 22 200 149 1,000 90 b. What are the net requirements of each item in the MPS? (Leave no cells blank - be certain to enter "0" wherever required.)