Quantitative Techniques
Complete each assessment using one of the two text softwares; either QM for Windows or Excel QM OR Microsoft Office Excel. And, also, write an explanation narrative (see details below).
Shows all work including model formulation and all applicable tables and graphs.
Submission is well formatted enabling ease of viewing.
Completes full problem.
a- For monthly volume of 300 tables, determine the total cost, total revenue, and profit.
b- Determine the monthly break-even volume for the Willow Furniture Company.
2- The Retread Tire Company recaps tires. The fixed annual cost of the recapping operation is $60,00. The variable cost of recapping a tire is $9. The company charges $25 to recap a tire.
a- For an annual volume of 12,000 tires, determine the total cost, total revenue, and profit.
b- Determine the annual break-even volume for the Retread Tire Company operation.
4-Evergreen Fertilizer Company produces fertilizer. The company fixed monthly cost is $25000, and its variable cost per pound of fertilizer is $0.15. Evergreen sells the fertilizer for $0.40 per pound. Determine the monthly break-even volume for the company.
8-If the maximum operating capacity of the Retread Tire Company, as described in Problem 2. Is 8,000 tires annually, determine the break-even volume as a percentage of that capacity.
11- If the Retread Tire Company in Problem 2 changes its pricing for recapping a tire from $25 to $31, what effect will the change have on the break-even volume?
19-Kim Davis has decided to purchase a cellular phone, but she is unsure about which rate plan to select. The “regular” plan changes a fixed fee of $55 per month for 1,000 minutes of airtime plus$0.33 per minute for any time over 1000 minutes. The “executive” plan changes a fixed fee of $100 per month for 1200 minutes of airtime of airtime plus $0.25 per minute over 1200 minutes.
a- If Kim expects to use the phone for 21 hours per month, which plan should she select?