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? $[

ENGR.ECONOMIC ANALYSIS
14th Edition
ISBN:9780190931919
Author:NEWNAN
Publisher:NEWNAN
Chapter1: Making Economics Decisions
Section: Chapter Questions
Problem 1QTC
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
ENGR.ECONOMIC ANALYSIS
ENGR.ECONOMIC ANALYSIS
Economics
ISBN:
9780190931919
Author:
NEWNAN
Publisher:
Oxford University Press
Principles of Economics (12th Edition)
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
Engineering Economy (17th Edition)
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
Principles of Economics (MindTap Course List)
Principles of Economics (MindTap Course List)
Economics
ISBN:
9781305585126
Author:
N. Gregory Mankiw
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
Managerial Economics & Business Strategy (Mcgraw-…
Managerial Economics & Business Strategy (Mcgraw-…
Economics
ISBN:
9781259290619
Author:
Michael Baye, Jeff Prince
Publisher:
McGraw-Hill Education