Problem 1:1An automobile manufacturer produces three car models. Each car requires acertain amount of factory time to be manufactured and yields a certain profit.There is a fixed amount of factory time already scheduled for next week. To meetthe market demands, the affiliated dealers have placed orders of the minimumnumber of cars of each model that they expect to receive. Suppose that the carmodels are known at the factory as T, C and L, and that 1200 worker-hours areavailable. The factory time required per car (in worker-hours), profit per car (indollars), and dealer orders (in cars) for each model are as follows. Formulate anoptimization problem that can be used to maximize the total profit.CarTimeProfitOrdersT10200102050020L3070015

Decision variable: Suppose T be the no. of car model T C be the no. of car model…

Answered: Problem 1:1 An automobile manufacturer…

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

In past 4 weeks, AOC (Arab oil company) started producing and distributing national engine oil to substitute French Total and Esso brands. Production reported to be in thousands: 2, 4, 3, 5 TG Thousand Gallons). AOC production will be calculated after 5 more weeks.
NO. 5 Jenny Company produces two types of pants: long pants and short pants. The cost of making a pair of short pants and a pair of long pants are RM 75 and RM 95 respectively. In one week, the company must produce at least 150 pants of cach type. The minimum weekly production is 500 pants. The short pants is sold for RM 120 cach and the long pants for RM 150 cach. Using the graphical method, find: a) The number of short pants and long pants to be made in a week in order to minimize the total production cost. b) The profit made at the minimum weekly production cost.
d) A company can produce three products A, B and C. the products yield a contribution of Kshs.8, 5 and 10 respectively. The products use a machine which has 400 hours capacity. Each unit of the product uses 2, 3 and 1 hour respectively of the machines capacity. There are only 150 units available in the period of a special component which is used singly in product A and C. Only 200kgs of a special alloy is available in the period. The usage of special alloy is 2kgs per unit and 4kgs per unit respectively. There is an agreement with a trade association to produce no more than 50 units of product B in the period. Advise the company on the production plan that will maximize contribution.
9. The VP of manufacturing for the N. L. Hyer Company is ready to decide on her sales and oper- ations plan for next year. The firm's single product (known throughout the adult puzzle trade as "Hyer's Hexagon") is "red hot," according to the VP of marketing, so she insists that backorders are not acceptable next year. Since the United Puzzlemakers Union is trying to organize the plant, the manufacturing VP decided the number of employees must remain constant (i.e., level) throughout all four quarters. Pertinent information is as follows: Quarter 1 I™ 2 3 Production Days 60 58 61 70 Demand Forecast 12,000 13,000 13,590 9,000 4 Beginning inventory = 1,000 units Regular time output rate = 10 units/day employee a. What daily production rate and number of employees will be required? b. How many units will be in inventory at the end of quarter 4?
12 Assuming there is no change in a product's price or the quantity demanded, if a business owner wants to increase her advertising expenses by $500 monthly, ut of this would cause total costs to and the break-even quantity to question Select one: O a. stay the same; increase. O b. increase; increase. O c. decrease; increase. O d. stay the same; decrease. O. e. decrease; stay the same. car wash pays $2.500 in rent, $500 in
The management of Swift Company has determined the aggregated demand schedule in the following units: Month Demand Jan 650 Feb 930 Mar 1110 Apr 1550 May 2120 Jun 3130 Jul 2870 Aug 1690 Sept 1530 Oct 1610 Nov 2110 Des 1330 Each worker can produce an average of 10 units per month and is paid $2,000 (payroll costs) at regular time per month. If workers go home early (undertime) they are paid the same as normal time (regular time). In accordance with the employment contract with the union, the company does not impose overtime hours and sub-contracts work. companies can recruit and train (hire & train) new workers for a fee of $2,000 and lay off per person for $ 500. Inventory cost $ 32 per unit at the end of each month. Currently the company employs 140 workers, to anticipate inventory is 0 then: Make a production plan using the workforce level to anticipate inventory by choosing an additional supply…
Q1: Pat Jones is the general manager at Denny’s Muffler, which has 3 locations and 27 employees. Currently, the office manager at 3 stores put input their weekly sales results into a spreadsheet and e-mail that spreadsheet to Pat on Friday by noon. Each week, Pat handles between 120 to 350 records of sales data, and another 100 to 300 records of customer data. Pat would be like to keep track of weekly sales, which customers are associated with each sale, the parts used for each sale, what work was done for each customer at each sale, and which parts were used for each sale. If Pat wants to improve his efficiency and effectiveness, which of the following applications would be the best for collecting and storing Pat’s data? 1) Excel 2) SAP3) Access4) Minitab5) Teams6) MySQL
To finance a vacation in 4 years, Elsie saves $410 at the beginning of every six months in an account paying interest at 13% compounded semi dash annually. (a) What will be the balance in her account when she takes the vacation? (b) How much of the balance will be interest? (c) If she waits an additional year to start her vacation, and continues to save the same amount of money, how much more money does she have to spend? Question content area bottom Part 1 a) The balance in her account will be $ enter your response here. (Round the final answer to the nearest cent as needed. Round all intermediate values to six decimal places as needed.) Part 2 b) The amount of interest will be $ enter your response here. (Round the final answer to the nearest cent as needed. Round all intermediate values to six decimal places as needed.) Part 3 c) She will have an extra $ enter your response here to spend on her vacation. (Round the final answer to the nearest cent as needed. Round all…
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
Exercise 3: Daily demand for a product of a computer manufacturer is 400,000 units. The company, on average, makes $150 net profit for each computer. The current fill rate is 86%. About 70% of their incomplete orders are back-ordered, and the rests are cancelled. The company is considering to improve the fill rate to 90% whose estimated daily additional operating cost (e.g.,improving the warehousing and transportation) is $2,000,000. What should be the minimum back-order cost to make this investment reasonable?
13. Lemon Company makes products X and Y, with the following production constraints representing two machines: Machine 1: 2X+3Y18 Machine 2: 2X+Y<10 If the profit equation is Z-4x+2y, then what is the maximum possible profit? a P18 b. P20 С. Р21 d. P24
Problem 7-37 (Algorithmic) The New England Cheese Company produces two cheese spreads by blending mild cheddar cheese with extra sharp cheddar cheese. The cheese spreads are packaged in 12-ounce containers, which are then sold to distributors throughout the Northeast. The Regular blend contains 65% mild cheddar and 35% extra sharp, and the Zesty blend contains 75% mild cheddar and extra sharp. This year, a local dairy cooperative offered to provide up to 8100 pounds of mild cheddar cheese for $1.30 per pound and up to 3500 pounds of extra sharp cheddar cheese for $1.50 per pound. The cost to blend and package the cheese spreads, excluding the cost of the cheese, is $0.30 per container. If each container of Regular is sold for $1.80 and each container of Zesty is sold for $2.10, how many containers of Regular and Zesty should New England Cheese produce? Do not round your interim computations. If required, round your answers to the nearest whole number. Let R number of containers of…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS