Problem 4: A canoe manufacturer employs 120 men, each of whom works for up to thirty hours per week. Half are employed in the woodwork department, 20 men work in the plastics department and the remainder are in the finishing department. The company makes a standard canoe, which sells at a profit of OR7, and a deluxe version, which produces a profit of OR10. A standard canoe requires 4.5 hours work in the woodwork department and 2 hours in each of the plastics and finishing departments. The times in the woodwork, the plastics and the finishing departments are 5, 1 and 4 hours respectively for the deluxe canoe. Marketing considerations dictate that not less than one third and not more than two thirds of the canoes made should be the deluxe version. How many hours per week are utilised if the company seeks to maximise its total profit?

Problem 4: A canoe manufacturer employs 120 men, each of whom works for up to thirty hours per week. Half are employed in the woodwork department, 20 men work in the plastics department and the remainder are in the finishing department. The company makes a standard canoe, which sells at a profit of OR7, and a deluxe version, which produces a profit of OR10. A standard canoe requires 4.5 hours work in the woodwork department and 2 hours in each of the plastics and finishing departments. The times in the woodwork, the plastics and the finishing departments are 5, 1 and 4 hours respectively for the deluxe canoe. Marketing considerations dictate that not less than one third and not more than two thirds of the canoes made should be the deluxe version. How many hours per week are utilised if the company seeks to maximise its total profit?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Colleen Company has gathered the following data pertaining to activities it performed for two of its major customers. Jerry, Inc. Kate Co. Number of orders 6 30 Units per order 1,000 420 Sales returns: Number of returns 4 5 Total units returned 50 140 Number of sales calls 13 5 Colleen sells its products at $290 per unit. The firm’s gross margin ratio is 20%. Both Jerry and Kate pay their accounts promptly and no accounts receivable is over 30 days. After using business analytics software to carefully analyze the operating data for the past 30 months, the firm has determined the following activity costs: Activity Cost Driver and Rate Sales calls $ 800 per visit Order processing 180 per order Deliveries 410 per order Sales returns 270 per return and $3 per unit returned Sales salary 107,000 per month Required: 1. Using customers as the cost objects, classify the activity costs…
Charles Lackey operates a bakery in Idaho Falls, Idaho. Because of its excellent product and excellent location, demand has increased by 5555% in the last year. On far too many occasions, customers have not been able to purchase the bread of their choice. Because of the size of the store, no new ovens can be added. At a staff meeting, one employee suggested ways to load the ovens differently so that more loaves of bread can be baked at one time. This new process will require that the ovens be loaded by hand, requiring additional manpower. This is the only production change that will be made in order to meet the increased demand. The bakery currently makes 1,800 loaves per month. Employees are paid $8 per hour. In addition to the labor cost, Charles also has a constant utility cost per month of $800 and a per loaf ingredient cost of $0.35 Current multifactor productivity for 640 work hours per month =0.27loaves/dollar (round your response to three decimal places).
Pranuec Company mai Tactures, assembles, and rebunds material handing equipment used Tn war ses and uistr iters. One product, called a Liftmaster, is assembled from four components: a frame, a motor, two supports, and a metal strap. Frandec's production schedule calls for 6000 Liftmasters to be made next month. Frandec purchases the motors from an outside supplier, but the frames, supports, and straps may be either manufactured by the company or purchased from an outside supplier. Manufacturing and purchase costs per unit are shown. Component Manufacturing Cost Purchase Cost Frame $39.00 $52.00 Support $12.50 $16.00 Strap $7.50 $8.50 Three departments are involved in the production of these components. The time (in minutes per unit) required to process each component in each department and the available capacity (in hours) for the three departments are as follows: Department Component Cutting Milling Shaping Frame 3.6 2.3 3.2 Support 1.4 1.8 2.7 Strap 0.9 1.8 Capacity (hours) 370 430…
Demand for stereo headphones and music players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for this year was as follows: MONTH DEMAND (UNITS) January 4,150 February 4,250 March 3,950 April 4,350 May 4,950 June 4,650 July 5,250 August 4,850 September 5,350 October 5,650 November 6,250 December 5,950 a. Using linear regression analysis, what would you estimate demand to be for each month next year? Using a spreadsheet, follow the general format in Exhibit 3.8. (Do not round intermediate calculations. Round your answers to 2 decimal places.) b. To be reasonably confident of meeting demand, Nina decides to use 3 standard errors of estimate for safety. How many additional units should be held to meet this…
1. Foxie Owl’s Besty Bagel shop makes fresh bagels. She has to buy raw materials fresh every day for selling on that day. She wants to know exactly how much should she spend on raw materials. Foxie did some analysis over the past month and came back with the following numbers: Daily demand was equally likely to be 200, 225, 250, 275, or 300 bagels. What should be the number of bagels on hand to satisfy a Fill Rate requirement of 96%, rounded to next integer value? Group of answer choices 300 275 286 263 2. Suppose that instead of a discrete demand distribution, Foxie’s shop determines that the daily demand for bagels is normally distributed, with a mean of 250 and a standard deviation of 35. Foxie still wants a Fill Rate of 98%. What is the appropriate level of on-hand inventory for Foxie’s shop? Group of answer choices 263 274 257 270
Acme, Corp. produces and sells tennis rackets. Each tennis racket is sold for $150 and average total costs per racket are $125, $100 of which are variable. Acme's fixed costs total $10,000 per month. What is Acme's unit contribution margin? A. $50 B. Neither of these C. $25
Jefferson Company’s demand for its only product exceeds its manufacturing capacity. The company provided the following information for the machine whose limited capacity is prohibiting the company from producing and selling additional units. Actual run time this week 6,106 minutes Machine time available per week 8,600 minutes Actual run rate this week 4.32 units per minute Ideal run rate 6.00 units per minute Defect-free output this week 11,315 units Total output this week (including defects) 15,500 units 1. Compute the utilization rate.2. Compute the efficiency rate. 3. Compute the quality rate. 4. Compute the overall equipment effectiveness (OEE).
Charles Lackey operates a bakery in Idaho Falls,Idaho. Because of its excellent product and excellent loca-tion, demand has increased by 25% in the last year. On far toomany occasions, customers have not been able to purchasethe bread of their choice. Because of the size of the store, nonew ovens can be added. At a staff meeting, one employeesuggested ways to load the ovens differently so that moreloaves of bread can be baked at one time. This new processwill require that the ovens be loaded by hand, requiring addi-tional manpower. This is the only thing to be changed. If thebakery makes 1,500 loaves per month with a labor produc-tivity of 2.344 loaves per labor-hour, how many workers willLackey need to add? (Hint: Each worker works 160 hours permonth.)
Manufacturers Inc. (MI) currently has a labor force of 10, which can produce 600 units per period. The labor cost is now $5000 per period per employee. The company has a long-standing rule that does not allow it to make use of any overtime. In addition, the product cannot be subcontracted, due to the specialized nature of the machinery that MI uses to produce it. As a result, MI can only increase/decrease production by hiring or laying off employees. The cost is $10000 to hire or lay off an employee. Inventory carrying costs are $200 per unit for any unsold items at the end of the period. The inventory level at the beginning of period 1 is 400 units. The forecast demand is 700 in period 1,600 in period 2,450 in period 3, 250 in period 4,500 in period 5, and 550 in period 6. a.) Compute the costs of the Chase Demand Strategy. b.) Compute the costs of the Level Strategy c.) Compare the costs of the two strategies. Which one is superior?
Manufacturers Inc. (MI) currently has a labor force of 10, which can produce 600 units per period. The labor cost is now $5000 per period per employee. The company has a long-standing rule that does not allow it to make use of any overtime. In addition, the product cannot be subcontracted, due to the specialized nature of the machinery that MI uses to produce it. As a result, MI can only increase/decrease production by hiring or laying off employees. The cost is $10000 to hire or lay off an employee. Inventory carrying costs are $200 per unit for any unsold items at the end of the period. The inventory level at the beginning of period 1 is 400 units. The forecast demand is 700 in period 1,600 in period 2,450 in period 3, 250 in period 4,500 in period 5, and 550 in period 6. a.) Compute the costs of the Chase Demand Strategy.
Problem 11-11 (Algo) Famous Albert prldes himself on being the Cookle King of the West. Small, freshly baked cookles are the specialty of his shop. Famous Albert has asked for help to determine the number of cookles he should make each day. From an analysis of past demand, he estimates demand for cookles as VROBARTLITY OF DENAND 0.04 DEEAND 1,800 dosen 2,000 2,200 0.10 0.20 2,400 2,600 2,000 3,000 0.26 0.15 0.03 0.14 ces Each dozen sells for $0.65 and costs $0.49, which includes handling and transportation. Cookles that are not sold at the end of the day are reduced to $0.30 and sold the following day as day-old merchandise. a. Compute the expected profit or loss for each cookie making decislon quantity. (Round your answer to the nearest whole number. Enter expected losses with a negative sign.) Cookles Baked (Dozen) Probability of Demand Expected Profit/Loss 1,800 0.04 2,000 0.10 2,200 0.28 2,400 0.26 2,600 0.15
Ranger Supply Company is a large manufacturer and distributor of office supplies.It is based in New York but sends supplies to firms throughout the United States.It markets its supplies through periodic mass mailings of catalogues to those firms.Its clients can make orders over the phone, and Ranger ships the supplies upondemand. Ranger has had very high production efficiency in the past. This isattributed partly to low employee turnover and high morale, as employees areguaranteed job security until retirement. Ranger already holds a large proportionof the market share in distributing office supplies in the United States. Its maincompetition in the United States comes from one U.S. firm and one Canadian firm.A British firm has a small share of the U.S. market but is at a disadvantage becauseof its distance. The British firm’s marketing and transportation costs in the U.S.market are relatively high.Although Ranger’s office supplies are similar to those of its competitors, it has…