please answer in 30 mins. 8:54expert.chegg.com/expertqna[1)CheggTime remaining: 00:09:55Operations ManagementA campany wants to plan production for the monthsof January, February, March and April. The demandin the aforementioned months is 35,000, 37,000,45,000 and 33,000, respectively. Profit per product;CU100,000 for products produced under regulartime, and CU85,000 for products producedovertime. The cost of keeping in stock isCU20,000/unit per month. Normal and overtimecapacities are 40,000 and 10,000 in January, 25,000and 5,000 in February, 30,000 and 10,000 in March,and 25,000 and 5,000 in April, respectively.Accordingly, the mass production plan that willmaximize the card (how much in normal work andhow much in each month for which monthovertime) using the Table Method and show theresults on the tableAnswerSkipExitII

Find the Given details below: Month January February March April Total Demand (Unit) 35000…

Answered: A campany wants to plan production for…

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

Grey Manufacturing Company expects sales to total 13,000 units in the first quarter, 12,000 units inthe second quarter, and 15,000 units in the third quarter of the current fiscal year. Company policyis to have on hand at the end of each quarter an amount of inventory equal to 10% of the followingquarter’s sales. Given this information, how many units should be scheduled for production in thesecond quarter?
The below is an extract from the fixed asset register of ABC Ltd as at 31 December 2019Date of PurchaseCostuseful lifeLand1-Jan-306,000,000.000Building28-Feb-172,000,000.0020Vehicle:650,000.00Toyota Hilux1-Oct-19 350,000.005Ford Ranger30-Jun-17 300,000.005Furniture and Fittings1-May-20150,000.002Activities throughout the 2020 Financial Period:1. New Machinery have been purchased on 01 April 2020 at a Cost of N$ 4000,000. The machinery has been installed on the 15 April 2020 and was available for use on the 01 May 2020. Machinery is the only property plant and equipment of the company that is measured according to the revaluation method.1.1. On the 30th of October 2020 management decided to revalue the machinery due to a drastic decline in the revenue from sale of machinery produced inventory.Net replacement cost for the machine as at the 30th of October 2020 is N$2 000 000.2. The Toyota Hilux was involved in an accident on 1 October 2020 due to the floods and was written off by the…
How much influence can the employee requirements for one, two, or three days have on the weekly sched-ule in the employee scheduling example? Explore this in the following questions:a. Let Monday’s requirements change from 17 to 25in increments of 1. Use SolverTable to see how thetotal number of employees changes.b. Suppose the Monday and Tuesday requirementscan each, independently of one another, increasefrom 1 to 8 in increments of 1. Use a two-waySolverTable to see how the total number ofemployees changes. c. Suppose the Monday, Tuesday, and Wednes-day requirements each increase by the same amount, where this increase can be from 1 to 8in increments of 1. Use a one-way SolverTableto investigate how the total number of employeeschanges.
Can anyone solve this problem? 1.Draw a network to represent the sequence ofstages involved in the preparation of budgets.2. Can the whole process be completed withinthe required period of 17 weeks?3. If it is necessary to reduce the time taken tocomplete the budgeting process, which stagesshould be investigated and why?4. Explain the difference between total float, freefloat and independent float. Show that stage 1has a free float of 3 weeks, of which 2 weeksare independent float.
Nice-Fit is a (fictional) small business producing outfits for costume parties and specialoccasions. Custom designs can be tailored to a customer’s request. Tom and Ann are theowners of the company and source all the fabric, design the outfits and make the costumesthemselves. Tom and Ann keep spreadsheets with information on the material purchased andcostumes made, but they find it difficult to keep track of their products, raw materials, andsales. The raw materials are supplied from a fabric company in India, and the production takesplace in a manufacturing company in China. The clothing is sold at local weekend markets,sold, or rented through costume hire shops, and sold at their physical store. Tom and Annreceive a small percentage of the sales and rentals of their costumes from the hire shops.They have no information on customers other than those who request custom designsdirectly from them. In 2020, the Covid-19 pandemic had a major impact on global economies,businesses and how we…
How much influence can the employee requirements for one, two, or three days have on the weekly schedule in the employee scheduling example? Explore this in the following questions: a. Let Monday’s requirements change from 17 to 25 in increments of 1. UseSolverTable to see how the total number of employees changes.b. Suppose the Monday and Tuesday requirements can each, independently of one another, increase from 1 to 8 in increments of 1. Use a two-way SolverTable to see how the total number of -employees changes.c. Suppose the Monday, Tuesday, and Wednesday -requirements each increase by the same amount, where this increase can be from 1 to 8 in -increments of 1. Use a one-way SolverTable to -investigate how the total number of employees changes.
A recently hired chief executive officer wants to reduce future production costs to improve the company's earnings, thereby increasingthe value of the company's stock. The plan is to invest $76,000 now and $58,000 in each of the next 6 years to improveproductivity. By how much must annual costs decrease in years 7 through 12 to recover the investment plus a return of 13% per year? The annual cost decreases by $....
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.
A goldsmith makes two types of jewelry. A model A ring is made with 1 g of gold and 1.5 g of silver and sells for 25 UM.Another model B ring sells for 30 UM and is made of 1.5 g of gold and 1 g of silver. If you only have 750 gof each metal, how many rings should be made of each type to obtain maximum profit?Requested:- Make Initial Table of the problem.- Obtain the Case Variables- Obtain the Objective Function- Get Restrictions- Create the Simplex Table- Obtain the Optimal Solution and the Slack Variables.Solve this operational research exercise.
SIMPLEX METHOD: Min C = 3X1 + 7X2 + 5X3 Subject to: X1 + X2 + X3 > 50 2X1 + 3X2 + X3 > 100 Based on the initial tableau, answer questions no. 1-5 What is the value of X3 on the Cj row? What is the value of S2 on the right-hand side/quantity column? What is the value of Zj on the right-hand side/quantity column? What is the value of X3 on the Cj – Zj row? What is the entering variable?
You own wheat warehouse with capacity of 20,000 bushels. At the beginning of month 1, you have 6,000 bushels of wheat. Each month, wheat can be bought and sold at the price per 1000 bushels given in the table Month Selling price ($) Purchase prie ($) 1 3 8 2 6 8 3 7 2 4 1 3 5 4 4 6 5 3 7 5 3 8 1 2 9 3 5 10 2 5 The sequence of events during each month is as follows: a. You observe your initial stock of wheat. b. You can sell any amount of wheat up to your initial stock at the current month's selling price. c. You can buy(at the current month's buying price) as much wheat as you want, subject to the warehouse size imitation. Your goal is to formulate an LP that can be used to determine how to maximise the profit earned over the next 10 months and solve using Excel solver or AMPL
1. Find the total simple interest on P12,500 at 8% for 2 years. 2. Find the total simple interest on P12,500 at 8% for 9 months. 3. How long will it take P80,000 to accumulate to P96,000 at 8% simple interest rate?

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