Part 2B *below.VoiceZen is one of the most trusted paint brands in the region. It has two existingmanufacturing plants located in Pasig and Cavite. The firm orders have been receivedfrom three large contractors. Information about the shipping cost for thecorresponding contractors with respect to the manufacturing plants is presented inthe table below. Each gallon of paint must undergo two processes: blending andtinting. The costs related to the operation of these processes are indicated as follows.ContractorABC). Upload the (handwritten) LP model corresponding to the problemOperationBlendingTintingBlendingTintingOrder size (gallon)7501,5001.500PlantPlant 1Plant 1Plant 2Plant 2Hours requiredper gallon0.100.250.150.20Shipping cost/gallonFrom Pasig1.802.602.10Production Costper hour3.803.204.003.10From Cavite2.002.202.25Hours available300360600720

Answered: Image /qna-images/answer/b4149b41-d734-4a2f-ba57-3608d28c2311.jpg

Answered: VoiceZen is one of the most trusted…

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

Please help solve the solution below. I need to have this done in 45 minutes and I am struggling to solve my last questions. Problem 2: Comp-Max Computers assembles computers and computer equipment. It is about to start production of threenew types of computers, called model X, Y, and Z, respectively. Each type will require assembly time, inspection time, andstorage space. The availability of each of these resources is limited. Specifically, available assembly time is 400 hours, available inspection time is 300 hours, and available storage space is 500 cubic feet (about 14.2 ms). The amount of eachresource required for the different products is reported in the table below. Model X earns a profit of $100 per unit, model Yearns a profit of $125 per unit, and model 2 earns a profit of $200 per unit. Due to some prior agreements with customers,Comp-Max must produce at least 12 model X computers. In addition, management requires that the fraction of totalproduction made up of model 2…
ABC Company is engaged in the production of processed meats like tocino, chicken longganisa, pork longganisa, and siomai both chicken and pork. Their famous product is pork longganisa and it sells like a hot potato before the pandemic came. They are selling their products in their stall in the public market of Lipa. Their products are also available in their residence located in Brgy. Marawoy, Lipa City. Both locations are accessible to their suki, basically one of the reasons why their business is doing well. But because of the pandemic the sales of ABC Company were affected and slow down. On the first 5 months of the pandemic, the business is still earning profits but on the succeeding months, slowly they experience losses. Aside from the covid 19 pandemic, another factors that influence in the loss of the company is the price of the raw materials like pork and chicken. They have a total of 10 employees who are in charge in the production and in the stall. How would you analyze the…
I need explaination and spreadsheet with formulas and step to step interpretation please.....The attached are first two pages of required assisance and below is the rest of instructions please consider all of them:c. Suppose the CEO says, “Projects 3 and 4 must be undertaken but not both.”Describe the constraint.d. Suppose the CEO says, “Projects 4 cannot be undertaken unless projects 1 and 3also are both undertaken.” Describe the constraints. Hint: You may need to add more than one constraint for this part.3. Multi-product Production Planning. Hart Manufacturing makes three products. Each product requires manufacturing operations in three departments: A, B, and C. The labor-hour requirements, by department, are as follows:Department Product 1 Product 2 Product 3A 1.50 3.00 2.00B 2.00 1.00 2.50C 0.25 0.25 0.25During the next production period, the labor-hours…
Homework #2 (about 700 words): Read the attached paper and watch the following webinar presentation on a sustainability mindset. Then answer the following two questions: https://southernct.blackboard.com/bbcswebdav/pid-2700856-dt-content-rid-38030675_1/xid-38030675_1. Kassel, K., Rimanoczy, I., & Mitchell, S. F. (2018). A sustainability mindset model for management education. In Developing a sustainability mindset in management education (pp. 3-37). Routledge. Link: Session #46 Isabel Rimanoczy: “What is the Sustainability Mindset?” https://www.youtube.com/watch?v=3_VVc9kLnUs Provide your own definition of (a) sustainability and (b) sustainable business in your own words. Briefly describe the sustainability mindset proposed by Kassel et al. (2018). According to Rimanoczy (2021), why do we have to learn about the sustainability mindset?
Please solve using Excel @Risk add-in the question is Textbook Problem from Practical Management Science 6th Edition Chapter 11.4 Problem 30P. In the solution please provided step-by-step excel formulas used. The full Question is attached in the image. Seas Beginning sells clothing by mail order. An important question is when to strike a customer from the company’s mailing list. At present, the company strikes a customer from its mailing list if a customer fails to order from six consecutive catalogs. The company wants to know whether striking a customer from its list after a customer fails to order from four consecutive catalogs results in a higher profit per customer. Thefollowing data are available:-> If a customer placed an order the last time she received a catalog, then there is a 20% chance she will order from the next catalog.-> If a customer last placed an order one catalog ago, there is a 16% chance she will order from the next catalog she receives.-> If a customer…
LO1 Examine how the construction industry impacts on the environment, and how changes in the industry can create broader social and economic benefits. 1) Explore how the construction industry has an impact on the built environment. 2) Examine how social and economic factors have an effect on the construction industry. 3) Assess how effective government targets and national statistics have been on environmental protection. 4) Evaluate the impact of specifying an alternative construction method on environmental protection.
Throughout his business's expansion, Andrew Langston has had to meet several challenges-not the least of which was selecting and using information systems to keep his business competitive. Information systems have played a critical role in QuickBiz's history. You explore how Andrew met those challenges in the chapters of Part Two:• In Chapter 4, "Business Hardware," you learn how to evaluate QuickBiz's hardware needs and determine whether it has used hardware resources wisely .• In Chapter 5, "Business Software," you learn how to determine the types of software QuickBiz needs as it grows, adds employees and customers, and streamlines its business processes.• In Chapter 6, "Business Networks and Telecommunications," you learn about the strategies OuickBiz uses to remain in constant contact with its messengers and customers-with the goal of improving its services .• In Chapter 7, "Databases and Data Warehouses," you learn the importance of one of business's most powerful…
Radiant wants to hire Cargo planes for transporting their goods. They contacted VIP Transportation Company to hire Cargo planes. VIP informed that they can provide two types of Cargo Planes. In addition, they provided the following cost related information about the two types Cargo planes- WT88 and BH54: Personnel Cost Fuel Cost Maintenance Cost WT88 2000 1000 2000 BH54 2500 1500 1000 Radiant has $200,000 to spend in personnel cost, $160,000 in fuel cost, and $80,000 in maintenance cost. Moreover, they have to hire at least two of each type of planes. If WT88 can carry 55 tons of goods and BH54 can carry 85 tons of goods, then find out the following using Linear Programming: What is the maximum amount Radiant can carry given their budget constraint? Can you solve using solver ? (I did this but I got a wrong answer) Data Personnel Cost Fuel Cost Maintenance Cost Tons WT88 2000 1000 2000 55…
Comprehensive Problem 1Part 4 and Part 6: The following is a comprehensive problem which encompasses all of the elements learned in previous chapters. You can refer to the objectives for each chapter covered as a review of the concepts. Note: You must complete parts 1, 2 and 3 before completing parts 4 and 6. Please note that part 5 is optional. Part 4: At the end of May, the following adjustment data were assembled. Analyze and use these data to complete parts (5) and (6). a. Insurance expired during May is $275.b. Supplies on hand on May 31 are $715.c. Depreciation of office equipment for May is $330.d. Accrued receptionist salary on May 31 is $325.e. Rent expired during May is $1,600.f. Unearned fees on May 31 are $3,210. Part 6: Journalize the adjusting entries. Then, post the entries to the attached spreadsheet from part 2. a. Insurance expired during May is $275.
1) Which of the following translates business plan into productionplanningAPPMPSMRPNone of the Above2) Master production schedule is a medium-range planning and it isused for quantity and timing ofcomponents and raw materialFinished goodsBoth A & B3) The manufacturing strategy which deploys hiring and laying ofworkers in order to match its production rate to demand is calledLevel Production StrategyChase Production StartegyHybrid StrategyNone of the above4) "In a level production strategy, if the firm makes annual 120,00units per annum, the permonth production can be estimatted by""120,00 /12""120,00 / 365"The information is not complete5) The Bill of material is an engineering documments that showsinclusive listing and sub-components to be used for end productTRUEFALSE6) A lead capacity usually increases or decreases its capacity in anticipation of demand, this is known as "Match strategyLead Capacity StrategyLag capacity strategy7) The most important output of MRP isBOMPlanned…
Problem 6 Part A:Available to promise in period 4 = 50Problem 6 Part B:PAB in period 7 = 35 In part A, the only thing that you need to do is to calculate the ATP in periods 1,4,5, and 7. In part B, remember that you are rolling through time. The part B solution spreadsheet starts with time period 2 and period 1 is now history. For the part B, you must capture all of the events that occurred during week 1. For example, I gave you that the beginning PAB is 45. If you had 20 in stock (from part A), you produced 50 as planned in period 1, and the actual demand for period 1 was 25, then the beginning PAB (your stock quantity) is 20+50-25=45. The forecast and MPS quantities will not change from part A to part B. After you accept each of the orders (simply add the new order quantities to the existing customer order quantities in the correct time bucket), you will then recalculate the PAB, and then recalculate the ATP.
Frober Co's institutional investors are becoming increasingly impatient for growth at the company. The directors have identified a significant opportunity in a new market but Frober doesn't currently have the capabilities to exploit that opportunity. The nature of Frober's work means that its processes require a number of high technology processes, and the directors have agreed that Frober must retain full control over its operations in any markets it moves into. In this context, which of the following is the MOST appropriate basis of growth for Frober Co?

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