Excel HW 3 Bruin Ski Package Distribution Plan FORMAT

Quantitative Methods

Price Quantity Total Revenue Fixed Cost Variable Cost Profit (Dollars per tote) (Totes) (Dollars) (Dollars) (Dollars) (Dollars) 10.00        44,000     16.00        44,000     40.00        44,000       If the firm shuts down, it must incur its fixed costs (FC) in the short run. In this case, the firm's fixed cost is $44,000 per day. In other words, if it shuts down, the firm would suffer losses of $44,000 per day until its fixed costs end (such as the expiration of a building lease). This firm's shutdown price—that is, the price below which it is optimal for the firm to shut down—is    per tote.

Please no written by hand solution

Tennis Products, Inc., produces three models of high-quality tennis rackets. The following table contains recent information on the sales, costs, and profitability of the three models: Average Quantity Current Total Variable Cost Contribution Margin Contribution Sold Price Revenue Per Unit Per Unit Margin* Model (Units/Month) ($) ($) ($) ($) ($) 15,000 30 450,000 15.00 15 225,000 В 5,000 35 175,000 18.00 17 85,000 10,000 45 450,000 20.00 25 250,000 Total $1,075,000 $560,000 *Contribution to fixed costs and profits. The company is considering lowering the price of Model A to $27 in an effort to increase the number of units sold. Based on the results of price changes that have been instituted in the past, Tennis Products' chief economist estimates the arc price elasticity of demand to be -2.5. Furthermore, she estimates the arc cross elasticity of demand between Model A and Model B to be approximately 0.5 and between Model A and Model to be approximately 0.2. Variable costs per unit are…

Quality solution for better ratings please

Selling price per large Snowie  $                    5.00     Ice per Snowie  $                    0.20 Spoon straw (need one per Snowie)  $                    0.02 Styrofoam cup (need one per Snowie)  $                    0.08 Napkin (need two per Snowie)  $                    0.02 Servings per gallon of syrup                            28 Cost per gallon of syrup (includes concentrate, preservative, and sugar)  $                    8.00 Hourly rate for workers  $                  10.00 Event registration fee per day  $                  25.00 Electricity, insurance, maintenance, and permit costs per month  $                250.00 Kiosk rental cost per month  $                650.00 Purchase cost of two ice shavers (5-year life)  $             3,180.00 Purchase cost of a flavor station (5-year life)  $             1,080.00   a. Number of days you anticipate opening the kiosk per month 20 b. Number of hours you will work (no wages required) per day 6…

XYZ company can manufacture their own products and sells them. They are able to control the demand by changing the price that is determined by the equation below. The company is thinking of maximizing their profit. The fixed cost is $1,000 per month and the variable cost is $40 per unit. Find the number of units that must be manufactured and sold monthly to maximize profit. (Demand D in the equation is monthly) Hint: Profit = Total Revenue - Total Cost 2,700 5,000 p = $38 + D for D > 1 D2 1 Add file

Find total revenue when price Is $45 per unit and the total quantity sold is 7

Solve all this question compulsory.....

ONLY TYPED SOLUTION

fast pleasssse

Find output of total revenue is $6400 and the price per unit is 400

I want answers for this question

The global pandemic 2020 has promoted a race to capture the market for introducing effective vaccine and treatments. (please use excel/word) a)-   If PFIZER is the sole vaccine provider given the following information, answer the questions below: Output Price/Unit Total Cost 1 5500 1000 2 5000 1200 3 4500 1500 4 4000 2500 5 3500 4000 6 3000 5700 7 2500 7500 8 2000 9400 9 1500 11400 10 1000 13500   Given the tabular information above find the profit-maximizing output and price also illustrate the same using the two-dimensional labeled diagram. Show the calculation as well. (use excel)                                                                        b)-    Assume if many firms enter into the business of providing vaccine determine:  How the demand curve of PFIZER would change and how it would now maximize its profit? The kind of market structure now PFIZER is forced to operate in? Also,…

Average Total Cost (Dollars per bike) QQ = 100 QQ = 200 QQ = 300 QQ = 400 QQ = 500 QQ = 600 1 140 60 40 80 160 320 2 230 110 40 40 110 230 3 320 160 80 40 60 140

Quantity of Resort Units Marginal Capacity Cost Marginal Operating Cost Peak Marginal Revenue Off-Peak Marginal Revenue Peak Demand Off-Peak Demand 150 $5,000 $1,000 $8,000 $2,000 $10,000 $2,500 200 $5,000 $1,000 $7,500 $1,500 $8,000 $2,000 250 $5,000 $1,000 $6,700 $1,000 $7,800 $1,750 300 $5,000 $1,000 $6,000 $750 $7,000 $1,250 350 $5,000 $1,000 $5,000 $500 $6,250 $1,000 The table above summarizes Gorgeous Sands Resort's marginal capacity cost, marginal operating cost, peak marginal revenue, off-peak marginal revenue, and its peak and off-peak demand for its resort units. Refer to the table above. What is the profit-maximizing number of resort units for Gorgeous Sands Resort during the off-peak period?       200     250     300     350

PRINT YOUR NAME (LAST) (FIRST) Aggregate Cost Data Unit Cost Data Average Average Average I Fixed Variable Total Cost TC Marginal Quantity Fixed Variable Total Change in I Cost of Output (FC) (VC) Cost ATC Cost Cost Total Cost (TC) (ATC) Plot MC at Output Cost Cost IFC VC $600 $ 0 $ 600 I XX XX XX XX $3.00 $300 50 100 600 300 900 I $6.00 $3.00 $9.00 100 1.00 150 200 600 400 | 3.00 2.00 5.00 50 .50 - 250 300 1050 I 2.00 1.50 1.00 350 400 1150 I 1.50 1.38 2.88 200 2.00 - 450 500 600 750 1350 I 1.20 1.50 550 600 600 1200 1800 3.00 10.00 - 650 700 2200 2800 I.85 3.15 PLOT THE APPROPRIATE DATA FROM THE PRECEDING TABLE ON THE GRAPHS ON P. 134 AND 135 BEFORE ANSWERING THE EIGHT QUESTIONS BELOW. QUESTIONS 5-8 ARE ON PAGE 136. 1. How is marginal cost (ATC/AQ) represented in your graph on page 134? 2. On your graph on page 135 Variable Cost per unit (VC/Q or average variable cost) is at a minimum at an output level of, units. 3. On your graph on page 135 Total Cost per unit (TC/Q or average…

Land's Bend sells a wide variety of outdoor equipment and clothing. The company sells both through mail order and via the internet. Random samples of sales receipts were studied for mail order sales and internet sales, with the total purchase being recorded for each sale. A random sample of 12 sales receipts for mail order sales results in a mean sale amount of $94.50 with a standard deviation of $19.25. A random sample of 17 sales receipts for internet sales results in a mean sale amount of $81.80 with a standard deviation of $20.75. Using this data, find the 80% confidence interval for the true mean difference between the mean amount of mail order purchases and the mean amount of internet purchases. Assume that the population variances are not equal and that the two populations are normally distributed. Step 3 of 3: Construct the 80% confidence interval. Round your answers to two decimal places.

Output quantity Total variable cost Total cost 0 $0 $250 25   450 50 300 X 75 375   100 600 850 125 X 1125 150 1200 X 175   1875 200 2000 2250

Cecil Green sells golf shirts. He knows that most people will not pay more than $40 for a golf shirt. Cecil needs a 35% markup on cost. What is the maximum Cecil should pay for his golf shirts?    I need help working this problem out. I know the answer is $29.63 but I need it explain to me in detail how to come up with this answer so I know how to work it out on my midterm Tuesday. Please help

Question 4. Please help with a & b. Thank you

If profit is $360 and total cost is $800 Calculate Total revenue

Calculate average revenue when total revenue is $4400 and units sold are 64 units

The following figures have been planned for a department. Shortages Employee discounts 2.5% Markdowns Expenses Profit 0.8% 4.2% 36.1% 4.8% Alteration Costs 2.3% Calculate the initial markup% that should be used in order to arrive at the planned figures

Bags/ variable average Participants fixed cost cost total cost variable cost cost marginal total revenue marginal total wt price $20 revenue profit 0 1700 0 1700 0 0 -1700 100 1700 500 2200 5 200 1700 1200 2900 6 57 2000 20 -200 4000 20 1100 300 1700 2700 4400 9 15 6000 20 1600 400 1700 5200 6900 13 25 8000 20 1100 500 1700 9000 10700 18 38 10000 20 -700 600 1700 15000 16700 25 60 12000 20 -4700 700 1700 23800 25500 34 88 14000 20 -11500 800 1700 36800 38500 46 130 16000 20 -22500 900 1700 55800 57500 62 190 18000 20 -39500 1000 1700 83000 84700 83 272 20000 20 -64700

12 st L8 Get & Transform Data 4 6 7 1 2 Available Product 3 8 9 10 11 12 13 A 14 15 16 17 18 19 20 All :X ✓ fx B Pounds made Workbook Links Queries & Connections 3000 Flour (ounce) 1500 Egg (piece) 4500 Labor (man-hour) Unit Price Variable Cost Demand UCM Adiucted C 3.2 1.5 6 D $12.50 $6.50 960 $6.00 2.6 1.5 5 Data Types $11.00 $5.70 928 $5.30 E 1.5 1 4 <1 $9.00 $3.60 1041 $5.40 F 0 0 0 0 Banana Muffin Choc Muffin Banana Cookies Choc Cookies Milk Bread White Bread 0.7 0.3 0.5 0 2.5 1.5 $6.00 $3.00 $2.20 $1.20 1084 1055 $3.80 $1.80 AV 0 0.8 1 3 G $7.00 $2.80 977 $4.20 Sort & Filter H Advanced 0

Price and cost (dollars per client) 100.00 90.00 MC 80.00 ATC 70.00 60.00 50.00 40.00 30.00 20.00 10.00 D MR + 4 8 10 Quantity (clients per day) 2.

help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working

(a) How many vacuums are supposed to be sold to achieve break even? (b) If Primark wants to earn a profit of $36,000, how many vacuum must be sold?

Isocost line and least-cost combination