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 consideredwill have fixed costs of $11,152 per month and variable costs of $1.23 per unit produced. Each item is sold to retailers at a price that averages $2.07a) The volume per month is required in order to break even = Blank 1 (in whole number)b) The profit or loss would be realized on a monthly volume of 61,000 units Blank 2c) The volume is needed to obtain a profit of $16,000 per month = Blank 3 (in whole number)d) The volume is needed to provide revenue of $23,000 per month = Blank 4 (in whole number)

Fixed Cost = $11,152 per monthVariable Cost = $1.23 per unitSelling price = $2.07 per unit

Answered: A producer of pottery is considering…

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

ABC Ltd. Wants to choose the best location for its new aluminum plant. The manager ofproductions and operations has three possible locations to choose from. His assistantrecommends that he use break-even analysis location technique to help determine whichlocation is best based on costs. . If total fixed cost = 40000 AVC = 20 Price per unit = 10 Break even point = 40000 / 20 - 10= 4000 So at the 4000 units of production, there will be no profit and loss as the total revenue is equal to the total cost. Demonstrate to the OM manager how to go about choosing the best location using thenumerical example you designed above.
Roche Brother is considering a capacity expansion of its supermarket. The landowner will build the addition to suit in return for $200,000 upon completion and a 5-year lease. The increase in rent for the addition is $10,000 per month. The annual sales projected through year 5 follows. The current effective capacity is equivalent to 500,000 customers per year. Assume a 2% pretax profit on sales Year 1 2 3 4 5 Customers 560,000 600,000 685,000 700,000 715,000 Ave. Sales per Customer 50.00 53.00 56.00 60.00 64.00 If Roche expands its capacity to serve 700,000 customer per year now (end of year 0), what are the projected annual incremental pretax cash flows attributable to this expansion? If Roche expands its capacity to serve 700,000 customer per year at the end of year 2, the landowner will build the same addition for $240,000 and a 3-year lease at $12,000 per month. What are the projected annual incremental pretax cash flows attributable…
Determine Fall's seasonal factor from the information below. Seasons Past Sales Spring 350 Summer 200 Fall 600 Winter 450 Total 1,600 Group of answer choices a. 0.8 b. 1.8 c. 2.5 d. 1.5 e. 2.0
The Blah Cafe operates a restaurant location in Fresno, CA where they serve food in an eclecticcasual blah whatever setting. Blah Cafe analyzes their operations in two seasonal periods – Spring& Summer being the first seasonal period and Fall & Winter being the second. The averagemonthly demand, with revenue and variable cost figures for both the seasonal periods is given in the data tableAs can be seen in the Table, demand is pretty high and robust in the Spring and Summer season,with demand falling in the Fall and Winter season.1. Help Blah Cafe develop an EXCEL spreadsheet model to determine the break-even point*demand quantity for each of the seasonal periods. Explain how you found the break-evenpoint. Should the restaurant be kept open during the Fall & Winter months? Explain.*At the Breakeven Point (demand), Total Revenue = Total Costs (or at Breakeven Point,Profit = zero). 2. Now given current demand for each season, what fixed cost will justify keeping therestaurant…
Location Fixed Cost Variable Cost A $100,000 $10 B $150,000 $7 C $200,000 $5 600 Annual 500 Cost ($000) 400 300 200 100 2 4 6 8 10 14 16 18 20 Q (000s of units) i. Plot the total cost curves in the chart provided above and identify the range over which each location would be best. ii. Use break-even analysis to calculate exactly the break-even quantity that defines each range.
Please answer in 30 Mint
Lancelot’s Barbecue makes its sauce using an old family recipe. Due to overwhelming response on its Instagram account in January 2020, it decides to sell directly to the public and is considering four locations. Two months later, the world shuts down due to the Covid-19 pandemic and Lancelot’s fails to produce a single bottle of its sauce. Which location would have been ideal for making no sauce? Cost Data Abilene Beaumont Conroe Dalhart Fixed costs $180,000 $220,000 $235,000 $265,000 Direct material cost per unit $10.50 $10.00 $10.00 $9.25 Direct labor cost per unit $3.90 $4.00 $2.75 $3.45 Overhead per unit $1.10 $1.00 $1.50 $1.20 Transportation cost per unit $1.10 $0.80 $1.25 $0.90 a. Dalhart b. Beaumont c. Conroe d. Abilene
b. An operations manager has narrowed down the search for a new King Kola plant to three locations. Fixed and variable costs follow. Location Fixed Cost Variable Cost A $100,000 $10 B $150,000 $7 C $200,000 $5 600 Annual 500 Cost ($000) 400 300 200 100 6 8 10 14 16 18 20 0 (000s of units) i. Plot the total cost curves in the chart provided above and identify the range over which each location would be best. ii. Use break-even analysis to calculate exactly the break-even quantity that defines each range.
A rental car firm’s executive is considering two different price structures: price per day versus price per mile. Identify a situation in which a price-per-day structure would most match the value that customers are willing to pay. Alternatively, identify a situation in which a price-per-mile structure would most match the value that customers are willing to pay.
Kindly help
East Texas Seasonings began as a small business in Athens Texas. Over the years, the company's success has exceeded the capacity of this one location so Mr. Sass, the owner opened 3 additional branches. Each of these branches house a unique source of the company's secret blend. In an attempt to increase efficiency, the company is preparing to build one processing center to serve its four sources of seasonings. The 4 source locations are at the coordinates shown below. Also, the volume from each source is provided. X-coordinateY-coordinate Volume Athens, Texas 30 40 100 Beaumont, Texas 20 15 400 Carthage, Texas 55 60 150 Denton, Texas 20 70 250 b. Calculate the volume-weighted center of gravity.
Mrs. Z, vice president for operations of XY, Inc., a manufacturer of imaginary product T, is constrained from meeting her 5-year forecast by limited capacity at the company’s two existing facilities, which are in San Diego, California (F1) and Grenville, South Carolina (F2). As her able assistant, you have been told that because of existing capacity constraints and the expanding market for the company’s product, a third plant is to be added. The real estate department has advised Mrs. Z that two potential sites seem particularly good, located in Waco, Texas (F3), and Norfolk, Nebraska (F4). The company ships the products to three demand markets in East (M1), Mid-West (M2), and West (M3), via its two cross-docking distribution centers in Colorado (D1) and Kentucky (D2). You are asked to find the optimal distribution strategy that will determine where the third facility be located (F3 or F4), and the best distribution pattern across the supply chain. The company consider the…

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