What is the fixed cost? $[ What are the Variable Costs? $[ If the merchandise is very popular among students and they need 2,000 units, what do you predict it would cost, based on the ove calculations? $ If the College of Engineering were to receive an offer from a different producer for a flat rate of $22 per shirt, what would be the eakeven point between the two scenarios? $[

Managerial Economics: Applications, Strategies and Tactics (MindTap Course List)
14th Edition
ISBN:9781305506381
Author:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Publisher:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Chapter8: Cost Analysis
Section: Chapter Questions
Problem 9E
icon
Related questions
Question
100%

SOLVE USING EXCEL PLEASE

 

There is no more information to provide. This should be all that is necessary. 

Suppose the College of Engineering is planning to sell merchandise this year. They don't know how many students will be interested
or how many will sell, so they've received three quotes for orders of different sizes. Assume the relationship is linear or best fit.
Cost Quote
Units
Small Order
Medium Order
Large Order
Extra Large Order
220
445
900
1500
a) What is the fixed cost? $
b) What are the Variable Costs? $
$5,000
$10,000
$18,900
$24,000
c) If the merchandise is very popular among students and they need 2,000 units, what do you predict it would cost, based on the
above calculations? $
d) If the College of Engineering were to receive an offer from a different producer for a flat rate of $22 per shirt, what would be the
breakeven point between the two scenarios? $
Transcribed Image Text:Suppose the College of Engineering is planning to sell merchandise this year. They don't know how many students will be interested or how many will sell, so they've received three quotes for orders of different sizes. Assume the relationship is linear or best fit. Cost Quote Units Small Order Medium Order Large Order Extra Large Order 220 445 900 1500 a) What is the fixed cost? $ b) What are the Variable Costs? $ $5,000 $10,000 $18,900 $24,000 c) If the merchandise is very popular among students and they need 2,000 units, what do you predict it would cost, based on the above calculations? $ d) If the College of Engineering were to receive an offer from a different producer for a flat rate of $22 per shirt, what would be the breakeven point between the two scenarios? $
Expert Solution
steps

Step by step

Solved in 5 steps

Blurred answer
Knowledge Booster
Value Added Method
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, economics and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Managerial Economics: Applications, Strategies an…
Managerial Economics: Applications, Strategies an…
Economics
ISBN:
9781305506381
Author:
James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Publisher:
Cengage Learning
Managerial Economics: A Problem Solving Approach
Managerial Economics: A Problem Solving Approach
Economics
ISBN:
9781337106665
Author:
Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:
Cengage Learning
Survey Of Economics
Survey Of Economics
Economics
ISBN:
9781337111522
Author:
Tucker, Irvin B.
Publisher:
Cengage,
Micro Economics For Today
Micro Economics For Today
Economics
ISBN:
9781337613064
Author:
Tucker, Irvin B.
Publisher:
Cengage,
Essentials of Economics (MindTap Course List)
Essentials of Economics (MindTap Course List)
Economics
ISBN:
9781337091992
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning
Economics For Today
Economics For Today
Economics
ISBN:
9781337613040
Author:
Tucker
Publisher:
Cengage Learning