V. Zarb, the marketing manager for Maltese Treasures Ltd, is preparing a sales budget for the year
Question:
V. Zarb, the marketing manager for Maltese Treasures Ltd, is preparing a sales budget for the year ended 30 June 2017. In reviewing the actual sales data for the previous year, the sales and marketing managers involved agree that the number of units of Valletta pictures sold in the year ended 30 June 2017 should represent a 20% increase over the previous year’s sales, Gozo print unit sales should increase 10%, and Maltese cross unit sales should decrease 8%. The managers’ projections took into consideration the general economic conditions and expected changes in consumer preferences. The selling prices of Valletta and Gozo artwork will increase 15% and the selling price of Maltese crosses will decline 5%. The percentages of each product’s sales occurring in each quarter are as shown below:
First quarter | Second quarter | Third quarter | Fourth quarter | |
Valletta pictures Gozo prints Maltese cross | 25% 20% 30% | 30% 25% 20% | 15% 35% 25% | 30% 20% 25% |
The actual product sales data for the year ended 30 June 2016 were:
Unit selling price | Total sales $ | ||
Valletta pictures Gozo prints Maltese cross | $55 85 23 | ||
Required
Prepare the marketing manager’s sales budget for the year ended 30 June 2017, showing projected dollar sales by quarter. Round all calculations to the nearest dollar.
Step by Step Answer:
Accounting
ISBN: 978-1118608227
9th edition
Authors: Lew Edwards, John Medlin, Keryn Chalmers, Andreas Hellmann, Claire Beattie, Jodie Maxfield, John Hoggett