business analysis
Questions Mr. Simon is considering the expansion of his business. He wants to produce additional trait-base pies: lemon, strawberry and cherry. The selling prices of these pies are set in terms of the apple pie price. The cherry pie is known to have the same price as an apple pic, the lemon pie is cheaper than the apple one by $ 1.00, and the strawberry pic costs $ 0.25 more than an apple pie. This expansion however raise the overhead cost to $ 33,000 As expected, Mr. Simon finds that the demand and processing cost equations as well as the unit ingredient costs are slightly different from one fruit to another see the table below) The demand equations are respectively Apple Pres Demanded = 52.4-4.2x Apple Pie Price Lemon Pies Demanded 55.6-4.6x Lemon Pie Price Strawberry Pies Demanded = 55-4.5 Strawberry Pie Price Cherry Pies Demanded 56.6-4.7xCherry Pie Price The apple pie is $9.12. The processing costs are respectively Apple: see Questions Lemon: Processing Cost-125+4.5x Production Strawberry: Processing Cost -12.4 +3.6x Production Cherry: Processing Cost-12.6+3.26x Production In addition, the ingredients costs are provided in the table below Apple Strawberry Cherry Total Unit cost fruit filing (5 per pie) Untos, douch Fixed cost (000's) 0,3 0,28 0,35 0,33 a. Compute the usual financial outcomes. In particular show the contributions of each pie type and deduce the profit b. Draw a stacked column plot of the revenue, the contribution, the ingredient cost and the processing cost with the fruits on the horizontal axis. Note: Create Sheet 08 containing all caleulations as well as the stacked column plot Question 9 While Simon is happy with the pie prices, volumes of pies sold and contributions of the individual four pic types, he notices that his production capacity is limited to 24,000 pies. For each additional pie to be produced he incurs a SOS cost, known as the overtime processing cost. a. By means of an appropriate IF statement implemented in an excel sheet (that you will label Sheer_09) find the new total cost processing. The usual processing cost will be renamed as "normal processing cost opposed to the overtime processing cost which occurs when the capacity limit of 24,000 pies is exceeded. b. Find the new ingredient costs, total cost, contributions and the profit Mr. Simon is considering the expansion of his business. He wants to produced from pios: lemn, strawberry and cherry. The selling prices of these pics are set in to otheke pie price. The cherry pic is known to have the same price as an apple pic theme s cheaper than the apple one by $1.00, and the strawberry pieco SO5 moh l epie This expansion however raises the overhead cost to $33.000 As expected. M. Simon finds that the demand and processing cost s as well as the ingredient costs are stilly different from one frutto mother see the the below The demand equations are respectively Apple PD 5 24-42 Alle Price Lemon Pies Demanded - 55.6-46 Le Plie Price Stratory Pies Demanded-55-45x Sabry Pie Price Cherry Pies Demande -566-47xCherry Pie Price The apple pie is $9.12. The processing costs are respectively Apples Questions Lemos: Proin C -125.45 Practice S herry Processing Cor-12436x Prado Cherry Processing Cost-1263.26 Production In addition, the ingredients costs are provided in the table below Apple Leme Sworry Cherry Unit contra filling Spot pic) Un cost To Compute the financial outcomes in a show the contributofach Type and deduce the profit b. Draw a stacked column plot of the reve, the contribution, the ingredients and the processing cost with the fruits on the horizontal Nel Create Sheets containing all calculations as well as the stacked complex Question While Simon is happy with the pie prices volumes of pies sold and individual four pe types, he notices that his production capacity is limited to 24.000 to be produced he cursa SOS cost own the vertic a of the Fee l a By means of an appropriate IF statement implemented in an cool short that you will label Sher O find the now to cost processing The was prece s will be named as "homal processing cost opposed to the time pres ent which occurs when the capacity limit of 24,000 pies is exceeded Find the new ingredients, concerties and the profit. Questions Mr. Simon is considering the expansion of his business. He wants to produce additional trait-base pies: lemon, strawberry and cherry. The selling prices of these pies are set in terms of the apple pie price. The cherry pie is known to have the same price as an apple pic, the lemon pie is cheaper than the apple one by $ 1.00, and the strawberry pic costs $ 0.25 more than an apple pie. This expansion however raise the overhead cost to $ 33,000 As expected, Mr. Simon finds that the demand and processing cost equations as well as the unit ingredient costs are slightly different from one fruit to another see the table below) The demand equations are respectively Apple Pres Demanded = 52.4-4.2x Apple Pie Price Lemon Pies Demanded 55.6-4.6x Lemon Pie Price Strawberry Pies Demanded = 55-4.5 Strawberry Pie Price Cherry Pies Demanded 56.6-4.7xCherry Pie Price The apple pie is $9.12. The processing costs are respectively Apple: see Questions Lemon: Processing Cost-125+4.5x Production Strawberry: Processing Cost -12.4 +3.6x Production Cherry: Processing Cost-12.6+3.26x Production In addition, the ingredients costs are provided in the table below Apple Strawberry Cherry Total Unit cost fruit filing (5 per pie) Untos, douch Fixed cost (000's) 0,3 0,28 0,35 0,33 a. Compute the usual financial outcomes. In particular show the contributions of each pie type and deduce the profit b. Draw a stacked column plot of the revenue, the contribution, the ingredient cost and the processing cost with the fruits on the horizontal axis. Note: Create Sheet 08 containing all caleulations as well as the stacked column plot Question 9 While Simon is happy with the pie prices, volumes of pies sold and contributions of the individual four pic types, he notices that his production capacity is limited to 24,000 pies. For each additional pie to be produced he incurs a SOS cost, known as the overtime processing cost. a. By means of an appropriate IF statement implemented in an excel sheet (that you will label Sheer_09) find the new total cost processing. The usual processing cost will be renamed as "normal processing cost opposed to the overtime processing cost which occurs when the capacity limit of 24,000 pies is exceeded. b. Find the new ingredient costs, total cost, contributions and the profit Mr. Simon is considering the expansion of his business. He wants to produced from pios: lemn, strawberry and cherry. The selling prices of these pics are set in to otheke pie price. The cherry pic is known to have the same price as an apple pic theme s cheaper than the apple one by $1.00, and the strawberry pieco SO5 moh l epie This expansion however raises the overhead cost to $33.000 As expected. M. Simon finds that the demand and processing cost s as well as the ingredient costs are stilly different from one frutto mother see the the below The demand equations are respectively Apple PD 5 24-42 Alle Price Lemon Pies Demanded - 55.6-46 Le Plie Price Stratory Pies Demanded-55-45x Sabry Pie Price Cherry Pies Demande -566-47xCherry Pie Price The apple pie is $9.12. The processing costs are respectively Apples Questions Lemos: Proin C -125.45 Practice S herry Processing Cor-12436x Prado Cherry Processing Cost-1263.26 Production In addition, the ingredients costs are provided in the table below Apple Leme Sworry Cherry Unit contra filling Spot pic) Un cost To Compute the financial outcomes in a show the contributofach Type and deduce the profit b. Draw a stacked column plot of the reve, the contribution, the ingredients and the processing cost with the fruits on the horizontal Nel Create Sheets containing all calculations as well as the stacked complex Question While Simon is happy with the pie prices volumes of pies sold and individual four pe types, he notices that his production capacity is limited to 24.000 to be produced he cursa SOS cost own the vertic a of the Fee l a By means of an appropriate IF statement implemented in an cool short that you will label Sher O find the now to cost processing The was prece s will be named as "homal processing cost opposed to the time pres ent which occurs when the capacity limit of 24,000 pies is exceeded Find the new ingredients, concerties and the profit
