Question

In: Accounting

Red Canyon T-shirt Company operates a chain of T-shirt shops in the southwestern United States. The...

Red Canyon T-shirt Company operates a chain of T-shirt shops in the southwestern United States. The sales manager has provided a sales forecast for the coming year, along with the following information:

Quarter 1 Quarter 2 Quarter 3 Quarter 4
Budgeted Unit Sales 36,000 56,000 28,000 56,000
  • Each T-shirt is expected to sell for $11.
  • The purchasing manager buys the T-shirts for $4 each.
  • The company needs to have enough T-shirts on hand at the end of each quarter to fill 21 percent of the next quarter’s sales demand.
  • Selling and administrative expenses are budgeted at $72,000 per quarter plus 10 percent of total sales revenue.


Required:
1.
Determine budgeted sales revenue for each quarter.



2. Determine budgeted cost of merchandise purchased for each quarter.



3. Determine budgeted cost of good sold for each quarter.



4. Determine selling and administrative expenses for each quarter.



5. Complete the budgeted income statement for each quarter.

Solutions

Expert Solution

Solution 1:
Red Canyon T-shirt Company
Sales Budget
Particulars Quarter 1 Quarter 2 Quarter 3
Budgeted Unit sales 36000 56000 28000
Selling Price per unit $11.00 $11.00 $11.00
Budgeted Sales revenue $396,000 $616,000 $308,000
Solution 2:
Red Canyon T-shirt Company
Budgeted cost of merchandise purchases
Particulars Quarter 1 Quarter 2 Quarter 3
Budgeted unit sales 36000 56000 28000
Add: Required ending Inventory (21% of next quarter's sales) 11760 5880 11760
Total Needs 47760 61880 39760
Less: Opening Inventory 7560 11760 5880
Required Purchases in units 40200 50120 33880
Cost per unit of T-shirt $4.00 $4.00 $4.00
Budgeted cost of merchandise purchases $160,800 $200,480 $135,520
Solution 3:
Red Canyon T-shirt Company
Budgeted Cost of goods sold
Particulars Quarter 1 Quarter 2 Quarter 3
Budgeted Unit sales 36000 56000 28000
Cost per unit $4.00 $4.00 $4.00
Budgeted Cost of goods sold $144,000 $224,000 $112,000
Solution 4:
Red Canyon T-shirt Company
Budgeted Selling and administrative expenses
Particulars Quarter 1 Quarter 2 Quarter 3
Budgeted Sales Revenue $396,000 $616,000 $308,000
Variable Selling and administrative expense (10%) $39,600 $61,600 $30,800
Fixed Selling and administrative expense $72,000 $72,000 $72,000
Budgeted Selling and administrative expenses $111,600 $133,600 $102,800
Solution 5:
Red Canyon T-shirt Company
Budgeted Income Statement
Particulars Quarter 1 Quarter 2 Quarter 3
Budgeted Sales Revenue $396,000 $616,000 $308,000
Less: Cost of goods sold $144,000 $224,000 $112,000
Budgeted gross Margin $252,000 $392,000 $196,000
Less: Budgeted Selling and administrative expenses $111,600 $133,600 $102,800
Budgeted Net operating income $140,400 $258,400 $93,200

Related Solutions

Red Canyon T-shirt Company operates a chain of T-shirt shops in the southwestern United States. The...
Red Canyon T-shirt Company operates a chain of T-shirt shops in the southwestern United States. The sales manager has provided a sales forecast for the coming year, along with the following information:Quarter 1Quarter 2Quarter 3Quarter 4  Budgeted Unit Sales32,00052,00026,00052,000         Each T-shirt is expected to sell for $20.The purchasing manager buys the T-shirts for $8 each.The company needs to have enough T-shirts on hand at the end of each quarter to fill 30 percent of the next quarter’s sales demand.Selling and administrative expenses...
Red Canyon T-shirt Company operates a chain of T-shirt shops in the southwestern United States. The...
Red Canyon T-shirt Company operates a chain of T-shirt shops in the southwestern United States. The sales manager has provided a sales forecast for the coming year, along with the following information:        Quarter 1 Quarter 2 Quarter 3 Quarter 4   Budgeted Unit Sales 40,000 60,000 30,000 60,000         •    Each T-shirt is expected to sell for $15. •    The purchasing manager buys the T-shirts for $6 each. • The company needs to have enough T-shirts...
Red Canyon T-shirt Company operates a chain of T-shirt shops in the southwestern United States. The...
Red Canyon T-shirt Company operates a chain of T-shirt shops in the southwestern United States. The sales manager has provided a sales forecast for the coming year, along with the following information: Quarter 1 Quarter 2 Quarter 3 Quarter 4 Budgeted Unit Sales 42,000 64,000 32,000 64,000 Each T-shirt is expected to sell for $17. The purchasing manager buys the T-shirts for $7 each. The company needs to have enough T-shirts on hand at the end of each quarter to...
Red Canyon T-shirt Company operates a chain of T-shirt shops in the southwestern United States. The...
Red Canyon T-shirt Company operates a chain of T-shirt shops in the southwestern United States. The sales manager has provided a sales forecast for the coming year, along with the following information: Budgeted Unit Sales Quarter 1 47,000 Quarter 2 74,000 Quarter 3 37,000 Quarter 4 74,000 Each T-shirt is expected to sell for $22. The purchasing manager buys the T-shirts for $9 each. The company needs to have enough T-shirts on hand at the end of each quarter to...
Red Canyon T-shirt Company operates a chain of T-shirt shops in the southwestern United States. The...
Red Canyon T-shirt Company operates a chain of T-shirt shops in the southwestern United States. The sales manager has provided a sales forecast for the coming year, along with the following information: Quarter 1 Quarter 2 Quarter 3 Quarter 4 Budgeted unit sales 50,000 80,000 40,000 80,000 Each T-shirt is expected to sell for $25. The purchasing manager buys the T-shirts for $10 each. The company needs to have enough T-shirts on hand at the end of each quarter to...
Red Canyon T-shirt Company operates a chain of T-shirt shops in the southwestern United States. The...
Red Canyon T-shirt Company operates a chain of T-shirt shops in the southwestern United States. The sales manager has provided a sales forecast for the coming year, along with the following information: Quarter 1 Quarter 2 Quarter 3 Quarter 4 Budgeted Unit Sales 49,000 78,000 39,000 78,000 Each T-shirt is expected to sell for $24. The purchasing manager buys the T-shirts for $10 each. The company needs to have enough T-shirts on hand at the end of each quarter to...
Red Canyon T-shirt Company operates a chain of T-shirt shops in the southwestern United States. The...
Red Canyon T-shirt Company operates a chain of T-shirt shops in the southwestern United States. The sales manager has provided a sales forecast for the coming year, along with the following information: Quarter 1-49000, Quarter 2-78000, Quarter 3- 39000 Quarter 478000 Budgeted Unit Sales. Each T-shirt is expected to sell for $24. The purchasing manager buys the T-shirts for $10 each. The company needs to have enough T-shirts on hand at the end of each quarter to fill 34 percent...
Red Canyon T-shirt Company operates a chain of T-shirt shops in the southwestern United States. The...
Red Canyon T-shirt Company operates a chain of T-shirt shops in the southwestern United States. The sales manager has provided a sales forecast for the coming year, along with the following information: Quarter 1 Quarter 2 Quarter 3 Quarter 4 Budgeted Unit Sales 41,000 62,000 31,000 62,000 Each T-shirt is expected to sell for $16. The purchasing manager buys the T-shirts for $6 each. The company needs to have enough T-shirts on hand at the end of each quarter to...
Red Canyon T-shirt Company operates a chain of T-shirt shops in the southwestern United States. The...
Red Canyon T-shirt Company operates a chain of T-shirt shops in the southwestern United States. The sales manager has provided a sales forecast for the coming year, along with the following information: Quarter 1 Quarter 2 Quarter 3 Quarter 4 Budgeted unit sales 48,000 76,000 38,000 76,000 Each T-shirt is expected to sell for $23. The purchasing manager buys the T-shirts for $9 each. The company needs to have enough T-shirts on hand at the end of each quarter to...
Red Canyon T-shirt Company operates a chain of T-shirt shops in the southwestern United States. The...
Red Canyon T-shirt Company operates a chain of T-shirt shops in the southwestern United States. The sales manager has provided a sales forecast for the coming year, along with the following information: Quarter 1 Quarter 2 Quarter 3 Quarter 4 Budgeted Unit Sales 37,000 57,000 28,500 57,000 Each T-shirt is expected to sell for $12. The purchasing manager buys the T-shirts for $5 each. The company needs to have enough T-shirts on hand at the end of each quarter to...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT