Table IProjectsWarehouseABSupply2003002001,5001,50030020010025001,5002.0003002002003.1.0001.000Demand2.0001.5001.0004,500Solve and find Uie lowest transoorLalion.cost Show your solutionns,

This question is related to the topic-Supply chain management and this topic falls under Operations…

Answered: Table I Projects Warehouse Supply 200…

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

b) What are the components of service package! S. Prepare an aggregate plan for the following information of demand forecast as given in the table below. Period 1 Demand (units) 55 2 49 Regular Production Cost Overtime production Cost Regular Production capacity 3 60 4 57 5 45 : Rs 60 per unit : Rs 80 per unit : 50 units per period : Rs 5 per unit per period Inventory cost Overtime Production capacity: 10 Units per period : Rs 150 per unit : Unlimited : Nil 6 60 7 8 50 65 9 55 Subcontracting cost Subcontracting capacity Beginning Inventory Use regular production and supplement using inventory, overtime and subcontracting.
A manager has the option of purchasing one, two, or three machines. Fixed costs and potential volumes are as follows:Number ofMachinesTotal AnnualFixed CostsCorrespondingRange of Output1 $ 9,600 0 to 3002 15,000 301 to 6003 20,000 601 to 900Variable cost is $10 per unit, and revenue is $40 per unit.a. Determine the break-even point for each range.b. If projected annual demand is between 580 and 660 units, how many machines shouldthe manager purchase?
Please do not give solution in image format thanku Bob's candle factory is considering three different manufacturing options. Option A uses hand labor with fixed costs of $10,000 and variable costs of $2.75/candle. Option B uses a combination of hand and automation with fixed costs of $15,000 and variable costs of $1.10/candle. Option C is highly automated with fixed costs of $20,000 and variable costs of $0.75/candle. a. If demand for Bob's candles is 2500, which option should he pick, and what is the cost? b. If demand for Bob's candles is 4500 which option should he pick, and what is the cost?
1. Eastern Visayas State University (EVSU) has facilities and faculty to handle an enrollment of 25,000students per semester. However, in an effect to limit class sizes to a reasonable level (under 2,000generally), the EVSU VPAA, placed a ceiling on enrollment of 18,000. Although there was ampledemand for all courses last semester, conflicting schedules allowed only 1,500 students percollege. There are 10 colleges in EVSU.a. What is the utilization rate of EVSU?b. What is efficiency of EVSU?
Deforrest Marine Motors manufactures engines for the speedboat racing circuit. As part of their annual planning cycle, they forecasted demand for the next four quarters. The number of available days of production and the anticipated demand are given below. Employees Production Rate Production Cost Backorder Cost Overtime Cost Overtime Limit Demand Q1 2,400 6,019,000 They also estimated many of the costs required to conduct operations planning. Some of these key figures are listed below. 30 70 units/employee/quarter Q2 2,200 $1,000/unit $200/unit/quarter $1,500/unit <= 25% of Reg. Production Q3 1,700 Q4 1,800 Hire Cost Fire Cost Subcontracting Cost Subcontracting Limit Inventory Cost Initial Inventory $1,200/employee $800/employee $1,800/unit 400 units maximum $100/unit/quarter 280 units Deforrest Marine Motors wishes to maintain the current number of employees for the entire year to follow a level strategy balanced with inventory and backorders as needed. What is the total cost of this…
Hickory Manufacturing Company forecasts the following demand for a product (in thousands of units) over the next five years. 1 2 3 4 5 86 90 Year Forecast demand Currently the manufacturer has seven machines that operate on a two-shift (eight hours each) basis. Thirty days per year are available for scheduled maintenance of equipment with no process output. Assume there are 250 workdays in a year. Each manufactured good takes 20 minutes to produce. a. What is the effective capacity of the factory? Round your answer down to the nearest whole number. units, year b. Given the five-year forecast, how much extra capacity is needed each year? Use a minus sign to enter an answer, if there is excess capacity, Round your answers to the nearest whole number. Year 1 Additional machines needed 2 1 24 Extra capacity needed (units) C. Does the firm need to buy more machines? If so, how many? When? If your answer is zero, enter "0". Round your answers up to the nearest whole number. 4 3 4 5 PE
Problem #2- Brown Manufacturing-Modified, from textbook page #198 If the annual demand is reduced to 8,000 units, the set-up costs increased to $120, inventory carrying cost increased to $0.60 per unit per year and the demand during the production period is maintained at 60 units per day and 80 units can be manufactured daily, calculate а. The optimum production quantity (Q*) per production run (or per production lot). b. ( ne length of each production run. с. ( The number of production runs per year. Page 2 of 4 Scanned with CamScanner
Problem 4. TT Racing and Performance Motor Corporation wishes to evaluate two alternative CNC machines for NHRA engine building. Use the AW method at 10% per year to select the better alternative. In-house Contract -250,000 -370,500 First cost, S Annual operating cost, $ per year Salvage value, $ Life, years -40,000 20,000 3 -50,000 30,000 5
Betty's Bakery has the following standard cost sheet for one unit of its most popular cake: Direct materials Direct labor SP SQ 1.2 pounds 0.8 hours $ 12.00 per hour $ 1.50 per pound During the month of May, the company made 640 cakes and incurred the following actual costs: Direct materials purchased and used (940 pounds), $1,222 Direct labor (700 hours), $8,050 Required: 1. Calculate the direct materials price variance. 2. Calculate the direct materials quantity variance. 3. Calculate the direct materials spending variance. 4. Calculate the direct labor rate variance. 5. Calculate the direct labor efficiency variance. 6. Calculate the direct labor spending variance. Note: For all requirements, Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Round your intermediate calculations to two decimal places. 1. Direct materials price variance 2. Direct materials quantity variance 3. Total direct…
Variable cells Cell Name Final Value Reduced Cost Objective Coefficient Allowable Increase Allowable Decrease $B$6 Activity 1 3 0 30 23 17 $C$6 Activity 2 6 0 40 50 10 $D$6 Activity 3 0 –7 20 7 1E+30 Constraints Cell Name Final Value Shadow Price Constraint R.H. Side Allowable Increase Allowable Decrease $E$2 Resource A 20 7.78 20 10 12.5 $E$3 Resource B 30 6 30 50 10 $E$4 Resource C 18 0 40 1E+30 22 What is the allowable range for the right-hand-side for Resource C?
S C 0 r e 4 b) 3.5 3+ 2.5 2 1.5 1 0.5 + 0 4 3.17 3.18 Malaysian Logistics Performance Index 3.45 3.49 Custom Logistics Efficiency Infrasturcture 3.65 Based on the above chart: a) 3.21 World Bank Logistics Performance Index 3.46 3.57 *Note: Score: 0 - Poor, 5- Excellent 3.34 Timeliness Track and Trace Quality and Logistics Cost Competency Malaysia Logistics Performance Index 3.52 Source: https://www.lpimy.com The above chart shows the comparison between the average Malaysia Logistics Performance Index (MLPI) and the World Bank Logistics Performance Index (WBLPI). Discuss five (5) key components measured in the survey. 3.48 The MLPI is a survey based measurement of the Malaysia logistics performance from the views of industry professionals. The objective of the survey is to evaluate the status of logistics performance for Malaysia. 3.28 Compare the trend of performance between MLPI and WBLPI.
A producer of pottery is considering the addition of a new plant to absorb the backlog of demand that now exists. The primary location being considered will have fixed costs of $7,900 per month and variable cost of 62 cents per unit produced. Each item is sold to retailers at a price that averages 85 cents. (Round all answers to a whole number.) a. What volume per month is required in order to break even? b. What profit would be realized on a monthly volume of 65,000 units? 85,000 units? c. What volume is needed to obtain a profit of $13,000 per month? d. What volume is needed to provide a revenue of $20,000 per month?

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

Table I Projects Warehouse Supply 200 300 200 1,500 1,500 300 200 100 2 500 1,500 2.000 300 200 200 3. 1,000 1,000 Dernand 2.000 1.500 1.000 4,500 Solve and find Lie lowest transJorLalion cost. Show vour solutions