MYLES
grade 26/50

part 2-4 -11

excel -13

Executive Summary

need to provide your interpretation of results and not just list them

grade=-2

According to the analysis on Curryrus.com, if the price stays constant during the year, the demand will be the same, during the course of the year.

Curryrus’s total revenue for the year of 2012 does not change for the months of January through May, it stays at $60500. Starting June 1, Sales increased by 5% thereafter:

  • $63525 for June
  • $66701.21 for July
  • $70036.31 for august
  • $73538.13 for September
  • $77215.03 for October
  • $81075.79 for November
  • $85129.58 for December

Curryrus’ cost of production involved materials and labor cost. Material costs for the year of 2012 were $1.00 per unit stayed the same at $6000. Direct labor costs were $.50 per unit, stayed the same at $3000 until the end of June, and then increased by 5% thereafter:

  • $3150 for July
  • $3307.5 for August
  • $3472.875 for September
  • $3646.519 October
  • $3828.845 for November
  • $ 4020.287 for December

Curryrus’s profit fell below $25000 during the months of January through August. From September to December, profit went up as follows:

  • $28378.23 for September
  • $35872.14 for October
  • $44940.75 for November
  • $ 55662.79 for December

Ndoh Myles

INSS 300

Discussion questions

  1. a. End of the month of December, inventory fell below 500 because there was an increase in the number of units sold. The more the company sells, the lower the inventory gets.

b. Profits were below $25,000 from January till July , and then gradually went up because Curryrus sold a good amount of its merchandise, increasing profit and lowering their inventory.

  1. Seven months had profits less than $25,000 and one month had inventory less than 500.

3. If the prices go up by 10% and the demand goes down by 10% then there will be a decrease in profit because for example if price goes up by 10% in January, then a unit price will be $12.1 and if demand goes down by 10%, then 4950 units will be demanded causing total revenue to be $59,895. There for, profits will be $59,895 - $36,500.50 = $23,394.5 which is less than the original profit of $23,999.50

costs will change due to advertising and inventory carrying costs changes!!!

Need to create another worksheet for What-If

(see assignment 2:Use a separate worksheet (call it What-IF) to see the effect of this policy and provide recommendations

grade -8

4. If SpicesrUs wants to take over Curryrus.com, it needs to consider these: Is Curryrus currently making any money? Is there a demand for their products? SpicesrUs needs to be better than Curryrus in order to be successful.

  • Their IT structure, Their SCM, CRM systems, are they compatible with ours?
  • Their sales and web presence
  • Transportation costs since spices will have to be transported from India
  • Quality control
  • International laws
  • Any antitrust problems
  • Political situation among countries

grade=-1