Question

BUDGETS #1 Create a sales budget. Thunder Creek Company expects sales of 18,000 units in January...

BUDGETS #1 Create a sales budget. Thunder Creek Company expects sales of 18,000 units in January 2018, 24,000 units in February, 30,000 units in March, 34,000 in April, and 36,000 in May. The sales price is $48 per unit. #2 Create a production budget. Thunder Creek wants to finish each month with 20% of next month's sales in units. #3 Create a Direct Materials Budget Thunder Creek Company uses 2 pounds of direct materials for each unit it produces, at a cost of $4.00 per pound. The company begins the year with 9,500 pounds of material in Raw Materials Inventory. Management desires an ending inventory of 25% of next month's materials requirements #4 Create a Direct Labor Budget Thunder Creek Company's workers require 30 minutes of labor to produce each unit of product. The labor cost is $20 per hour Budget #5: Create a Manufacturing Overhead Budget "1. Thunder Creek Company prepares its Manufacturing Overhead Budget. For each direct labor hour, the variable overhead costs are: Indirect Materials = $1.00 per DLH; Indirect Labor Cost = $1.30 per DLH; Maintenance = $1.20 per DLH" 2. The Fixed Overhead Costs per month are: Salaries of $40,000, Depreciation =$20,000 and Maintenance = $10,000. 3. ROUND the predetermined overhead allocation rate to two decimal places. Manufacturing overhead is allocated using direct labor hours. Budget #6: Create a Cost of Goods Sold Budget Thunder Creek Company uses the first-in, first-out (FIFO) inventory costing method. The Beginning Finished Goods Inventory is $86,400 consisting of 3,600 units. Budget #7: Selling and Administrative Expense Budget Thunder Creek Company's variable supplies expense per month is $3.00 per unit. The fixed selling and administrative expenses per month consist of Salaries: $245,000; Advertising: $30,000; and Depreciation: $28,000 Budget #8: Budget Income from Continuing Operations (Tie it all together) 2018 Jan Feb Mar Q1 Total Budgeted Sales Revenue $- Budgeted Cost of Goods Sold - Budgeted Gross Profit - Budgeted Selling and Administrative Expenses - Budgeting Income from Continuing Operations $- $- $- $- i mostly just need help with costs of goods sold, the rest i seem to be ok with.

0 0
Add a comment Improve this question Transcribed image text
Know the answer?
Add Answer to:
BUDGETS #1 Create a sales budget. Thunder Creek Company expects sales of 18,000 units in January...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Thunder Creek Company expects sales of 18,000 units in January 2018, 24,000 units in February, 30,000...

    Thunder Creek Company expects sales of 18,000 units in January 2018, 24,000 units in February, 30,000 units in March, 34,000 in April, and 36,000 in May. The sales price is $34 per unit. Prepare a sales budget 2018 Budget #1: Sales Budget Feb Q1 Total Аpril Jan Mar May Budgeted units to be sold Sales price per unit Total Sales Thunder Creek wants to finish each month with 20 % of next month's sales in units. Prepare a production budget....

  • I need help with JUST 5,6, and 7 please 3 L12 x ✓ fx I B C D E F G H I 1 Thunder Creek Company expects sales of 18,000...

    I need help with JUST 5,6, and 7 please 3 L12 x ✓ fx I B C D E F G H I 1 Thunder Creek Company expects sales of 18,000 units in January 2018, 24,000 units in February, 30,000 units in March, 34,000 in April, and 36,000 in May. The sales price is $34 per unit. 2 Prepare a sales budget. 2018 4 Budget #1: Sales Budget Jan Feb Mar 01 Total April May 5 Budgeted units to be...

  • Tichina Scales S E AutoSave A 8 - = scales_Miller-Nobles_6e-12e-Using Excel_Ch22_Start - Protected View - Excel...

    Tichina Scales S E AutoSave A 8 - = scales_Miller-Nobles_6e-12e-Using Excel_Ch22_Start - Protected View - Excel The Home Insert Draw P age Layout Formulas Data Review View Help Search PROTECTED VIEW Be careful tiles from the Internet can contain viruses. Unless you need to edit, it's safe to stay in Protected View Enable Iditing A1 X ✓ MASTER BUDGETS F A B C D E T J K L M N O P R S T 9 Requirements Possible Points...

  • Morganton Company makes one product and it provided the following information to help prepare the master budget:

     Morganton Company makes one product and it provided the following information to help prepare the master budget: a. The budgeted selling price per unit is $70. Budgeted unit sales for June. July. August, and September are 9.100. 22,000, 24,000, and 25,000 units, respectively. All sales are on credit. b. Forty percent of credit sales are collected in the month of the sale and 60% in the following month. c. The ending finished goods inventory equals 20% of the following month's unit sales. d. The...

  • Royal Company is preparing budgets for the second quarter ending June 30. Last year's sales for...

    Royal Company is preparing budgets for the second quarter ending June 30. Last year's sales for the corresponding period were: A. The company expects this year's sales to increase by 25%. The selling price is $13 per unit. Prepare a Sales Budget. B. The company desires to have finished inventory on hand at the end of each month equal to 30 percent of the following month's budgeted unit sales. On March 31, there were 3,000 units on hand. Prepare a...

  • Exercise 13-13 Sheffield Company has accumulated the following budget data for the year 2017. 1. Sales: 31,410 units, u...

    Exercise 13-13 Sheffield Company has accumulated the following budget data for the year 2017. 1. Sales: 31,410 units, unit selling price $89. 2. Cost of one unit of finished goods: direct materials 1 pound at $5 per pound, direct labor 3 hours at $12 per hour, and manufacturing overhead $8 per direct labor hour. 3. Inventories (raw materials only): beginning, 10,240 pounds; ending, 15,220 pounds. 4. Selling and administrative expenses: $170,000; interest expense: $30,000. 5. Income taxes: 30% of income...

  • Morganton Company makes one product and it provided the following information to help prepare the master budget: The bu...

    Morganton Company makes one product and it provided the following information to help prepare the master budget: The budgeted selling price per unit is $65. Budgeted unit sales for June, July, August, and September are 8,200, 12,000, 14,000, and 15,000 units, respectively. All sales are on credit. Forty percent of credit sales are collected in the month of the sale and 60% in the following month. The ending finished goods inventory equals 20% of the following month’s unit sales. The...

  • Sales Forecast & Product Budget table numbers (units) April: Budget (880 units) & Sales (805 units)...

    Sales Forecast & Product Budget table numbers (units) April: Budget (880 units) & Sales (805 units) may: Budget (1,100 units) & Sales (900 units) june: Budget (1075) & Sales (1025 units) july : budget (1125 units) & sales (875 units) Delray Manufacturing needs to better budget and analyze costs. While Delray has experienced high sales growth, it has struggled to effectively manage costs and inventories. Delray aims to end each month with direct materials inventory equal to 40% of next...

  • Required Information The following information applies to the questions displayed below.) Morganton Company makes one product...

    Required Information The following information applies to the questions displayed below.) Morganton Company makes one product and it provided the following Information to help prepare the master budget: a. The budgeted selling price per unit is $60. Budgeted unit sales for June, July, August, and September are 9,200, 23,000, 25,000, and 26,000 units, respectively. All sales are on credit. b. Thirty percent of credit sales are collected in the month of the sale and 70% in the following month. C....

  • 1. The DL budget, S&A budget, unit cost and budgeted income statement: P.S. Corporation makes one...

    1. The DL budget, S&A budget, unit cost and budgeted income statement: P.S. Corporation makes one product and it provided the following information to help prepare the master budget for the next four months of operations: The budgeted selling price per unit is $120. Budgeted unit sales for January, February, March, April and May are 4,200;   4,400;   5,000;   4,800; and 5,100 units, respectively. All sales are on credit. Regarding credit sales, 20% are collected in the month of the sale...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT