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 38,000 58,000 29,000 58,000 Budgeted unit sales. • Each T-shirt is expected to sell for $13. 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 fill 23 percent of the next quarter's sales demand. Selling and administrative expenses are budgeted at $76,000 per quarter plus 18 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 expense for each quarter. 5. Complete the budgeted income statement for each quarter.

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 38,000 58,000 29,000 58,000 Budgeted unit sales. • Each T-shirt is expected to sell for $13. 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 fill 23 percent of the next quarter's sales demand. Selling and administrative expenses are budgeted at $76,000 per quarter plus 18 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 expense for each quarter. 5. Complete the budgeted income statement for each quarter.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Edward Food Processing Company is a wholesale distributor of biscuits in Holborn.The Company has achieved steady growth over the past few years while Biscuitprices have been on the increase. The Company is planning its budget for the nextfinancial year. Presented below are the data used to project the current year’s aftertax income of £110,400. £Average Sales Price per Box 4.00Average variable costs per Box Cost of Biscuits 2.00 Profit on sale 0.40 Total 2.40Annual fixed cost Selling 160,000 Administrative 280,000 Total 440.000Expected annual sales volume (390,000 boxes) £1,560,000Tax rate 20%Biscuit manufacturers have announced that they will increase prices of theirproducts by an average of 15% in the coming year due to increase in material andlabour costs. Edward Food Processing expects same rates or levels as the currentyear Required: (b) Calculate the Sales price per box that the company must charge to cover the15% increase in the costs of biscuits and still maintain the…
Beauty Spa & Co. manufactures a specialised luxury spa that is supplied to five-star hotels around the country. The owner provides you with the following information to prepare its 1st quarter budget: July, August, and September. Budgeted sales are as follows: Month Sales ($) Units Sold May 25,000 250 June 28,000 280 July 30,000 300 August 40,000 400 September 35,000 350 October 37,000 370 Additional information: i) Purchases are budgeted at $5.00 per unit and are paid for in full in the month after purchase. ii) Closing inventory must equal 50% of the next month’s sales. iii) Sales (which are all on credit) are collected as follows: 60% in the month of sale; 30% in the month after the sale; 5% in the second month after the sale. iv) The balance in the bank account as of 30 June is $10,000. Required (show your workings for each question): Prepare a purchases budget (in units and $) for the 1st…
I need some help with this problem
Molander Corporation is a distributor of a sun umbrella used at resort hotels. Data concerning the next month's budget appear below: Selling price per unit Variable expense per unit Fixed expense per month Unit sales per month $ 23 $ 17 $ 4,920 970 Required: 1. What is the company's margin of safety? (Do not round intermediate calculations.) 2. What is the company's margin of safety as a percentage of its sales? (Round your percentage answer to 2 decimal places (i.e. 1234 should be entered as 12.34).)
Molander Corporation is a distributor of a sun umbrella used at resort hotels. Data concerning the next month's budget appear below: Selling price per unit. Variable expense per unit Fixed expense per month Unit sales per month. $ 23 $18 $ 4,200 990 Required: 1. What is the company's margin of safety? (Do not round intermediate calculations.) 2. What is the company's margin of safety as a percentage of its sales? (Round your percentage answer to 2 decimal places (i.e. 1234 should be entered as 12.34).) 1. Margin of safety (in dollars) 2. Margin of safety percentage %
Molander Corporation is a distributor of a sun umbrella used at resort hotels. Data concerning the next month's budget appear below: Selling price per unit $ 25 Variable expense per unit $ 17 Fixed expense per month $6,880 Unit sales per month 1,010 Required: 1. What is the company's margin of safety? (Do not round intermediate calculations.) 2. What is the company's margin of safety as a percentage of its sales? (Round your percentage answer to 2 decimal places (i.e. .1234 should be entered as 12.34).)
Beauty Spa & Co. manufactures a specialised luxury spa that is supplied to five-star hotels around the country. The owner provides you with the following information to prepare its 1st quarter budget: July, August, and September. Budgeted sales are as follows: Month Sales ($) Units Sold May 25,000 250 June 28,000 280 July 30,000 300 August 40,000 400 September 35,000 350 October 37,000 370 Additional information: i) Purchases are budgeted at $5.00 per unit and are paid for in full in the month after purchase. ii) Closing inventory must equal 50% of the next month’s sales. iii) Sales (which are all on credit) are collected as follows: 60% in the month of sale; 30% in the month after the sale; 5% in the second month after the sale. iv) The balance in the bank account as of 30 June is $10,000. Required (show your workings for each question): Prepare the schedule of expected cash collections from…
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 34,000 54,000 27,000 54,000 Each T-shirt is expected to sell for $18. 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 fill 28 percent of the next quarter’s sales demand. Selling and administrative expenses are budgeted at $68,000 per quarter plus 14 percent of total sales revenue. Required:. Determine budgeted cost of merchandise purchased for quarters 1, 2, and 3.. Determine budgeted cost of good sold for quarters 1, 2, and 3.. Determine selling and administrative expenses for quarters 1, 2, and 3.. Complete the budgeted income statement for quarters 1, 2, and 3.
Scholar Suppliers manufactures backpacks for students. The backpacks come in two sizes: Small, and Large. Scholar Suppliers anticipates the following sales volumes and prices for the coming period: Size Sales Volume Selling Price Small 3,000 backpacks $25 each Large 6,000 backpacks $75 each What is the budgeted level of revenue for the coming period?
Edward Food Processing Company is a wholesale distributor of biscuits in Holborn.The Company has achieved steady growth over the past few years while Biscuitprices have been on the increase. The Company is planning its budget for the nextfinancial year. Presented below are the data used to project the current year’s aftertax income of £110,400. £Average Sales Price per Box 4.00Average variable costs per Box Cost of Biscuits 2.00 Profit on sale 0.40 Total 2.40Annual fixed cost Selling 160,000 Administrative 280,000 Total 440.000Expected annual sales volume (390,000 boxes) £1,560,000Tax rate 20%Biscuit manufacturers have announced that they will increase prices of theirproducts by an average of 15% in the coming year due to increase in material andlabour costs. Edward Food Processing expects same rates or levels as the currentyear. Required: Determine the Volume of sales the company must achieve in the comingyear to maintain the same net income as projected for the current yearif 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 on hand at the end of each quarter to fill 25 percent of the next quarter’s sales demand. Selling and administrative expenses are budgeted at $80,000 per quarter plus 10 percent of total sales revenue. Required: Determine budgeted sales revenue for each quarter. Determine budgeted cost of merchandise purchased for each quarter. Determine budgeted cost of good sold for each quarter. Determine selling and administrative expense for each quarter. Complete the budgeted income statement for each quarter.
Molander Corporation is a distributor of a sun umbrella used at resort hotels. Data concerning the next month’s budget appear below: Selling price per unit $ 30 Variable expense per unit $ 19 Fixed expense per month $ 9,570 Unit sales per month 1,020 Required: 1. What is the company’s margin of safety? (Do not round intermediate calculations.) 2. What is the company’s margin of safety as a percentage of its sales? (Round your percentage answer to 2 decimal places (i.e. .1234 should be entered as 12.34).)