Minimum Profit Possible Made on Drinks in Different Climates :: Profit Consumerism Sales Essays

Minimum Profit Possible Made on Drinks in Different Climates Create the minimum profit possible using the predicted amount of how many hot and cold drink would be sold in different weather climates and the price limits for the two drinks as provided in the ICT booklet. Evaluation Task 5 ================= Holly Grove High School Price Pledge Model ------------------------------------------ For this task, I needed to (as stated in the ICT booklet) create the minimum profit possible using the predicted amount of how many hot and cold drink would be sold in different weather climates and the price limits for the two drinks as provided in the ICT booklet. I used the formulas that I knew to calculate totals on the Microsoft Excel spreadsheet and thus to create the minimum profit. I had to ensure that my minimum profit did not go lower than 0 for this would mean that I would not be able to pay for costs such as Programme printing and public address system etc. Now, I am going to evaluate my work going through what was incorrect with each attempt I also did not read the instructions properly and failed to respond to the fact that the hot drinks should either be  £0.55 or  £0.60, therefore the total profit result is completely and I needed to revise the model completely. I choose the cold drink prices because when it was a cold weather climate the cold drink profit was going to be small as people prefer hot drinks in this weather climate, whereas on a hot day, the hot drink profit is going to small, as people prefer cold drinks in this weather climate. Using the correct instructions, my profits decreased rapidly. 40% of the profits were the final profits, which I would use for my final model, however the total profit for the hot weather climate was very high compared to the other profits, which were all under  £4.00. The profits for the warm climate and the mild climate were both below  £1.50, however I checked that they could not go any lower by decreasing the cold drink price by  £0.01 to  £0.53 and  £0.54, however the profits went into the minus numbers. For my third attempt, I decreased the profit for the hot weather