Chris Zarb, the marketing manager for Maltese Treasures Ltd, is preparing a sales budget for the year ended 30 June 2025. In reviewing the actual sales data for the previous year, the sales and marketing managers agree that the number of units of Valletta pictures sold in the year ended 30 June 2025 should represent a 25% increase over the previous year’s sales, Gozo print unit sales should increase 5%, and Maltese cross unit sales should decrease 4%. 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 10%. The percentages of each product’s sales occurring in each quarter are as shown as follows.

Required Prepare the marketing manager’s sales budget for the year ended 30 June 2025, showing projected dollar sales by quarter.

Transcribed Image Text:

Valletta pictures Gozo prints Maltese cross First quarter Second quarter Third quarter Fourth quarter 25% 20% 30% 30% 25% 20% 15% 35% 25% 30% 20% 25% The actual product sales data for the year ended 30 June 2024 were as follows Unit selling price Total sales Valletta pictures $155 $ 356 500 Gozo prints 185 333 000 Maltese cross 123 258 300