GOVERNMENT NSW TAFE Part 1: Sales budget preparation Prepare a Sales budget for 'Health is care' Cafe situated in a Blacktown city hospital for 2016. Health is care Cafe-Sales data for the year ended December 2015 Product Unit Sales Selling Price ($) Sales Revenue ($) Coffee 345 300 1035 Tea 100 2.50 250 Hot chocolate 125 3.00 375 Cold drinks 100 2.00 200 Iced donuts 200 1.00 200 Cakes 300 2.00 600 Total 1170 2.27 2660 Analysis of the local market and a trend over the past two years was conducted. A demographic report has been produced and following information has been determined in setting the budget for 2016. It is estimated that the following would occur during that period: 1. Unit sales of coffee will increase by 10% 2. Sales of tea will decline by 5% and 3. Sales of iced donuts will increase by 120% 4. The selling price of coffee needs to decrease to $2.50 to meet competitors pricing 5. Cakes prices need to fall to $1.80