1.

Tiger Paws Company is preparing its master budget for 2019. Relevant data pertaining to its sales is included below. Create a Sales Budget for the year ending December 31, 2019. Sales for the year are expected to total $1,200,000 units. Quarterly sales are 20%, 25%, 30% and 25% respectfully as a percentage of total sales unit. The sales price is $50 per unit for the first three quarters and $55 per unit beginning in the fourth quarter Step 1: Prepare Tiger Paws Company Sales Budget for the year ending December 31,2019

2.

Tiger Paws Company is preparing its master budget for 2019. Relevant data pertaining to its sales is included below. Create a Production Budget for the year ending December 31, 2019. Sales in the first quarter of 2020 are expected to be 10% higher than the budgeted sales for the first quarter of 2019. Management desires to maintain the ending finished goods inventories at 25% of the next quarter's budgeted sales volume. Step 2: Prepare Tiger Paws Company Production Budget for year ended December 31, 2019. This should be the 2nd Excel worksheet for this project. Worksheet 1 will be the Sales Budget; worksheet 2 will be Production Budget.

3.

Tiger Paws Company is preparing its master budget for 2019. Relevant data pertaining to its sales is included below. Create a Direct Materials Budget for the year ending December 31, 2019. Each unit will require 3 pounds of raw materials at a cost of $5 per pound. Management desires to maintain raw materials inventories at 5% of the next quarter's production requirements. Assume the production requirements for the first quarter of 2020 are 810,000 pounds. Step 3: Prepare Tiger Paws Company Direct Materials Budget for year ended December 31, 2019. This should be the 3rd Excel worksheet for this project. Worksheet 1 will be the Sales Budget; worksheet 2 will be Production Budget; and worksheet 3 will be the Materials Budget.