Analyzing Christmas Sales

You discover that a product sale was made and recorded in December for $128,600; the product had not yet been shipped. The cost

Compute the projected profit for the order quantities suggested by the management team under three scenarios: worst case in which sales = 10,000 units, most likely case in which sales = 20,000 units, and best case in which sales = 30,000 units.

I would now like to examine Wal-marts financial data. Wal-Mart’s revenue improved over these three years by $39,736 million which is a gross increase of 9.1%. Additionally the Cost of Sales climbed from

1. a. The simulation indicates that 584 is the optimum stocking quantity. Daily profit at this stocking quantity is $331.4346.

b. Determine the two product numbers with the largest total dollar sales for subsequent follow-up to verify the selling prices and quantities shipped.

Sales (in $ 1000s)= 16,020.78118 + 149.15175 * %spanishsp – 44.16538 * %dryers – 112.48017 * %freezer – 79.84655 * %sch0-8 + 9,393.82229 * comtype1 + 3,802.26442 * comtype2 – 3,123.24462 * comtype7

On the morning of January 17, 1993, before the annual buying trip to Germany for the 1993 Christmas season, the toy buyer for the chain of Hightower Department Stores named Julia Brown was reviewing the performance of some models of stuffed animals tested for sales during 1992. Every time Julia’s on the trip, she would buy some stuffed animals for testing. Fifty was the minimum amount the manufacturers require. Based on Julia’s years of buying experience, the tested result would give Julia a clear estimation about how many new stuffed animals she needed to order. Figure 1 in below shows the timeline of how Julia buys the toys for the company:

In our second assumption, instead of using the cost of goods per cases in 1986, we try to use the percentage it counts in the total expenses which is 50.4% and to find the sales needed to break-even. The detail of the calculation is shown in the answer for questions d. The result is that 95,635, a little bit higher than the estimated sales of 90,000.

Actual sales = 1686 (in million €) and Break even sales = 1126.61(in million €)

1. The local Mastermind store sells innovative educational toys. Part of their service is giving advice to customers about the best toys for a particular age group, which requires having more customer service representatives in the store. During the month long Christmas buying season, it makes half of its $500,000 yearly sales. Its contribution margin on average is 40% and its fixed costs for the year are about $150,000. The owner believes that she could make even higher sales, if she had more customer service representatives on the floor during the peak season. She plans on hiring four more people for 200 hours each at $20 per hour. How much additional revenue does she have earn to the nearest dollar

What formula or function does he put in columns B through F in Row 13 that will give him the total expenses for the week in each category?

However, if the difference between the total sales and the total cash received (for the period ending December

A result on the next page shows that at sales price of $21.50, the sales quantity rises to 1,140,085 units and net profit turns to positive for the first time. Besides, if a company continues to reduce the price further, at the point of $15.50, it is where the company’s profit on product 101 is in the highest position as it gives the net profit of $3,901,908.

* Refer sheet “30000 Sales” for cost incurred and Gain/loss for AIFS for different scenarios and actual sales volume of 30000.

Using the data provided from Exhibit 3 in the case in regards to sales data broken down for each company operated store in North America we derived the figures in the table below.