Question

Preparing a Sales Budget Patrick Inc. sells industrial solvents in 5-gallon drums. Patrick expects the following units to be sold in the first three months of the coming year: January 41,000 February 38,000 March 50,000 The average price for a drum is $35. Required: Prepare a sales budget for the first 3 months of the coming year, showing units and sales revenue by month and in total for the quarter. Do not include a multiplication symbol as part of your answer. Patrick Inc. Sales Budget For the Coming Quarter January February March 1st Quarter Total Units Price $ $ $ $ Sales $ $ $ $

Answer 1

Answer:

Patrick Inc.      

Sales Budget    

For the First Quarter    

January February March Total Quarter 1

Sale Units  41,000   38,000   50,000   129,000  

Average Selling Price per Unit $35.00  $35.00  $35.00  

Sales Value   $1,435,000   $1,330,000   $1,750,000   $4,515,000  

Explanation:

The Sales unit for each month is multiplied by its average sales price for e.g for January (41,000 units × by $35 = $ 1,435,000)

The Quarter totals (Units and sales Values in $) are added up to give the answer under the heading of Total Quarter 1.

The working is also attached with the answer.

Download xlsx