It is March, and the annual NCAA Basketball Tournament is down to the final 4 teams....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
It is March, and the annual NCAA Basketball Tournament is down to the final 4 teams. Randy Kitchell is a t-shirt vendor who plans to order t-shirts with the names of the final 4 teams from a manufacturer and then sell them to the fans. The fixed cost of any order is $750, the variable cost per t-shirt depends on the quantity ordered. A quantity discount reduces the cost per shirt for larger orders, according to the table shown below. Randy's selling price during the tournament is $10. However, after the tournament Randy will have to sell any remaining t-shirts at a reduced price of $4 each. Build a spreadsheet model that will let Randy experiment with different values for demand and his order quantity. (IF and VLOOKUP functions must be used) Quantity ordered Cost per shirt (at least) 0 to 199 (0) $13 200 to 399 (200) $11 400 to 599 (400) $9 600 to 799 (600) $7 800 to 999 (800) $5 Create a two-way table to show the sensitivity of profit to changes in Demand and Order Quantity. Put Demand as the row, Order Quantity as the column. Use the values 200, 400, 600, 800, 1000 for both. Order Demand 200 400 600 800 1000 200 Quantity 400 600 800 1000 It is March, and the annual NCAA Basketball Tournament is down to the final 4 teams. Randy Kitchell is a t-shirt vendor who plans to order t-shirts with the names of the final 4 teams from a manufacturer and then sell them to the fans. The fixed cost of any order is $750, the variable cost per t-shirt depends on the quantity ordered. A quantity discount reduces the cost per shirt for larger orders, according to the table shown below. Randy's selling price during the tournament is $10. However, after the tournament Randy will have to sell any remaining t-shirts at a reduced price of $4 each. Build a spreadsheet model that will let Randy experiment with different values for demand and his order quantity. (IF and VLOOKUP functions must be used) Quantity ordered Cost per shirt (at least) 0 to 199 (0) $13 200 to 399 (200) $11 400 to 599 (400) $9 600 to 799 (600) $7 800 to 999 (800) $5 Create a two-way table to show the sensitivity of profit to changes in Demand and Order Quantity. Put Demand as the row, Order Quantity as the column. Use the values 200, 400, 600, 800, 1000 for both. Order Demand 200 400 600 800 1000 200 Quantity 400 600 800 1000
Expert Answer:
Answer rating: 100% (QA)
Quantity ordered Cost per shirt at least 0 to 199 0 13 200 to 399 200 11 400 to 599 400 9 600 to 799 ... View the full answer
Related Book For
Probability And Statistics For Engineering And The Sciences
ISBN: 9781305251809
9th Edition
Authors: Jay L. Devore
Posted Date:
Students also viewed these mathematics questions
-
"internet radios" for streaming audio, and personal video recorders and players. Describe design and evaluation processes that could be used by a start-up company to improve the usability of such...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
DoorDash acquired 51% of the common stock of Wolt on December 31, 2021, for $8,100,000,000. At the date of acquisition, Wolt reported common stock with a par value of $10,000,000,000, additional...
-
Anderson Company is faced with the following PERT network situation (time in days): Required: (1) Calculate te (expected time) for each activity, to two decimal places. For each activity, the...
-
Your client, John Butler, is an avid Houston Astros fan. Last March at the Astros' home opener, as a result of a random drawing of those in attendance at the game, John won 300 Shipley Do-Nut...
-
The exact amounts of cola in different cans Levels of Measurement. State whether the data described are discrete or continuous and explain why?
-
Im not sure we should lay out $500,000 for that automated welding machine, said Jim Alder, president of the Superior Equipment Company. Thats a lot of money, and it would cost us $80,000 for software...
-
List two reasons why it s important to keep records of risk assessments.
-
People in a city are asked if they support a new recycling law. (a) What are the cases? (b) What is the variable and is it quantitative or categorical?
-
servant leadership Based on the topic Resources, in your opinion, what is the best piece of advice? How will this help you in your career and personal life? How would implementing this advice affect...
-
On June 1, 2025, Bonita contracted with Black Construction to have a new building constructed for $4,720,000 on land owned by Bonita. The payments made by Bonita to Black Construction are shown in...
-
A spherical buoy of diameter 0.6m and mass 30kg is attached to the seabed by mooring rope and floats fully submerged. determine the tension in the mooring rope. the density of sea water is 1020kgm^-3.
-
5. For the 0-1 Knapsack Problem, the item #1 has weight of 4 and the value of $12; the item #2 has weight of 1 and the value of $1; the item #3 has weight of 5 and the value of $10; and the item #4...
-
Let = {0, 1} and consider the state-transition diagram given in Figure 1. 0 1 A 0 0 B D 1 0 Figure 1: State-transition diagram for Question 4. (a) Give examples of three strings that are accepted by...
-
What is the process involved in cleaving plasmid DNA using restriction enzymes, and how does this method contribute to molecular biology research and genetic engineering endeavors?
-
Read the business startup idea of Daffodil then develop a mission statement, and do strategic planning, include objectives and competitive differentiation, then develop tactical, operational, and...
-
Test your confidence in the following Project Decisions: SI. # Question 01 02 03 04 05 06 07 08 09 10 How many years did it take to construct the largest Egyptian Pyramid- Pyramid of Cheops? When was...
-
From the following table, calculate the variances and discuss each one in relation to the following questions: i Is the variance positive or negative in terms of business performance? ii What are the...
-
Several years ago, Catherines Cattery Supplies signed a contract to deliver 5000 units of a special product each year to one of its customers at a price of $15 per unit. This contract, which runs for...
-
The Anderson Group has identified the following capital expenditure proposals as acceptable. Only $150 000 is available for investment. Required: Determine the combination of proposals to be...
Study smarter with the SolutionInn App