Sign In
Not register? Register Now!
Essay Available:
Pages:
2 pages/β‰ˆ550 words
Sources:
Check Instructions
Style:
APA
Subject:
Business & Marketing
Type:
Case Study
Language:
English (U.S.)
Document:
MS Word
Date:
Total cost:
$ 8.64
Topic:

Determining the Gross Margin Ratio

Case Study Instructions:

I will updated insturction and question later. and because this is a group case, so total 6 questions. you just answer question 1 and 2 is ok.
1. What is the Gross Sales of all the sugar products for last quarter? and how is the gross sales split between granulated and powdered sugar?
2. For what product variant is the Gross Margin % the highest?
I want to make sure just answer this 2 questions, and i updated the case instruction, Please note that he adjusted some of the data in the question . thank you
Please note that we have updated the case study to correct a couple of typos:
• page 3 at the bottom: "Total Powdered Sugar sales in the 12x1 kg version was 1630 tons" in old case is not correct. The sentence should read: "Total Sugar sales was 1,630 tons"
• page 4 last bullet point: "... G&A cost was SEK 910,00" in the old case is not correct. It should be "SEK 910,000"
• page 4 bullet point: "Total advertising spend on the three variants were SEK 1,269,000 ". It should be "SEK 2,069,000
• page 3 gross margin "SEK 8,885,000" is not correct. Gross margin should be SEK 9,856,000
• page 3 OP% "4,45%" should be"4,5%"

Case Study Sample Content Preview:
1 The total Gross Sales for all sugar products are SEK 33,453,380.68. It must be noted that this amount does not yet include the Discounts and other deductibles per sugar variant. The following table (Table 1) shows the breakdown of gross sales for the Granulated Sugar Variants 12x1 kg, Granulated sugar variants 6x2 kg, Powdered Sugar 12x1 kg variants are SEK 17,895,156.46, SEK 11,203,222.40, and SEK 4,355,001.82, respectively.
In order to get this value, each of the sales weight was initially calculated. To do this, the author first multiplied the 1440 tons of granulated sugar sales by their corresponding percentage (60% for 12x1 kg variant; 40% for 6x2 sugar variants). Subsequently, the Total weightage of the Granulated sugar sales (1440 tons) was then deducted from the Total Sugar sales (163o tons) to determine its value. Both of these were then converted to kilograms (kg).
After having the weightage of each variant, these was then multiplied to the existing prices to find the Gross Sales for each of the sugar variants. Finally, by adding the gross sales for each variant, the author was able to deduce the Total Gross Sales for all of the sugar variants which is equal to SEK 33,453,380.68.
Table SEQ Table \* ARABIC 1 - Breakdown of Gross Sales per Variant of Sugar LINK Excel.Sheet.12 "C:\\Users\\John Louis Aguila\\Desktop\\Marketing Assignment Sugar Case Study - Excel Sheet.xlsx" "Sheet1!R3C4:R8C8" \a \f 4 \h \* MERGEFORMAT
Product

Formula

Sales (kg)

Existing Prices*


Gross Sales/variant

Granulated sugar variants 12x1 kg

1440 x .6

72,062.00

SEK 248.33


SEK 17,895,156.46

Granulated sugar variants 6x2 kg

1440 x .4

47,959.00

SEK 233.60


SEK 11,203,222.40

Powdered Sugar 12x1 kg

1630 - 1440

15,787.00

SEK 275.86


SEK 4,355,001.82




Gross Sales


SEK 33,453,380.68

*price per...
Updated on
Get the Whole Paper!
Not exactly what you need?
Do you need a custom essay? Order right now:
Order

πŸ‘€ Other Visitors are Viewing These APA Case Study Samples:

HIRE A WRITER FROM $11.95 / PAGE
ORDER WITH 15% DISCOUNT!
Order Now