Question

Master Budget for: Serious Business, Inc. Enter your name: Enter your ID The facts for this problem are presented on the FactSerious Business, Inc. The company is preparing its budget for the coming year, 2019. The first step is to plan for the firstUtilities Maintenance 0.45 0.25 Fixed costs per month Salaries Depreciation Property taxes Insurance Janitorial 42,000 16,800

Master Budget for: Serious Business, Inc. Enter your name: Enter your ID The facts for this problem are presented on the Facts tab of this workbook. Instructions - Your solutions should be clearly labeled on the Solutions tab of this workbook. For the first quarter of 2019, do the following. (a) Prepare a sales budget. This is similar to Illustration 21-3on page 1088 of your textbook. (b) Prepare a production budget. This is similar to llustration 21-5 on page 1089 of your textbook. (c) Prepare a direct materials budget. (Round to nearest dollar) This is similar to lilustration 21-7 on (d) Prepare a direct labor budget. (For calculations, round to the nearest hour.) This is similar to litu (e) Prepare a manufacturing overhead budget. (Round intermediate amounts to the nearest dollar Rules: *Use Excel's functionality to your benefit. Points are lost for lack of formula. Use proper formats for schedules, following the referenced textbook examples Use dollar-signs and underscores where appropriate Double-check your work! Verify your formula and logic! Grading Guidelines Effective Use of Excel Facts, Logic Completeness Spelling, Punctuation, Value Format 40% 20% 30% 10%
Serious Business, Inc. The company is preparing its budget for the coming year, 2019. The first step is to plan for the first of that coming year. The following information has been gathered from their managers. Sales Information Period Units November December January February March 114,000 Actual 102,000 Actual 112,000 Planned 113,000 Planned 116,000 Planned 125,000 Planned 137,500 Planned ri May Unit selling price 12.00 Finished Goods Inventory Planning The company likes to keep 10% of the next month's unit sales in finished goods ending inventory Accounts Receivable & Collections Sales on Account 100% Collections Activity Month of Sale Month after Sale Balance at 12/31/18 85% 15% 185,000.00 $ Materials Inventory Costs & Planning Direct Materiais Amount Used per Unit Cost 0.75 lb Metal The company likes to keep 5% of the material needed for the next month's production in materials ending inventory 2 lb Accounts Payable & Disbursements Purchases on Account 100% Payment Activity Month of Purchase Month after Purchase Balance at 12/31/18 50% 50% 120,000 Direct Labor & Costs Time per Unit Production Pay Rate/Hour 12 minutes 8.00 Manufacturing Overhead Costs Variable costs per direct labor hour Indirect materials Indirect labor 0.30 0.50
Utilities Maintenance 0.45 0.25 Fixed costs per month Salaries Depreciation Property taxes Insurance Janitorial 42,000 16,800 2,675 1,200 1,300
0 0
Add a comment Improve this question Transcribed image text
Answer #1

a) Sales Budget Feb 113,000 Jan Mar Total Planned Units to be sold Selling Price/unit Estimated Sales 112,000 341,000 12 1,34c) Direct Material Buget Total (Jan- Mar) 342,300 Dec Jan Feb Mar Apr Production in Units 103,000 112,100 113,300 116,900 126d) Direct labor Budget Total (Jan Feb Mar) 342,300 Dec Jan Mar Apr Production in Units Time per unit (in minutes) Total timee) Manufacturing Overhead Budget Jan Feb Mar Total 0.30 $ 224,200 0.30 $ 226,600 Indirect Material per Diect labour hour A Di

Add a comment
Know the answer?
Add Answer to:
Master Budget for: Serious Business, Inc. Enter your name: Enter your ID The facts for this probl...
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
  • How do I prepare a direct labor budget that is similar to Illustration 22.11 of the...

    How do I prepare a direct labor budget that is similar to Illustration 22.11 of the textbook. (illustration included below) (Please show how you calculated the budget, and round to the nearest hour.) Illustration 22.11 below H C D E F G Serious Business, Inc. The company is preparing its budget for the coming year, 2020. The first step is to plan for the FIRST QUARTER of that 2 coming year. The following information has been gathered from their managers...

  • Dalley Manufacturing is preparing its master budget for the first quarter of the upcoming year. The...

    Dalley Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Dalley Manufacturing's operations: (Click the icon to view the data.) (Click the icon to view additional data.) Read the requirements. Requirement 1. Prepare a schedule of cash collections for January, February, and March, and for the quarter in total. Dalley Manufacturing Cash Collections Budget For the Quarter Ended March 31 Month January February March Quarter Cash sales Credits sales Total...

  • Waterways Corporation is preparing its budget for the coming year, 2020. The first step is to...

    Waterways Corporation is preparing its budget for the coming year, 2020. The first step is to plan for the first quarter of that coming year. The company has gathered information from its managers in preparation of the budgeting process. Sales Unit sales for November 2019 114,000 Unit sales for December 2019 102,000 Expected unit sales for January 2020 114,000 Expected unit sales for February 2020 113,000 Expected unit sales for March 2020 117,000 Expected unit sales for April 2020 126,000...

  • This is all one question. Thank you, I will give you a thumbs up if correct!...

    This is all one question. Thank you, I will give you a thumbs up if correct! Waterways Corporation is preparing its budget for the coming year, 2020. The first step is to plan for the first quarter of that coming year. The company has gathered information from its managers in preparation of the budgeting process. Sales Unit sales for November 2019 Unit sales for December 2019 Expected unit sales for January 2020 Expected unit sales for February 2020 Expected unit...

  • Prepare a production budget for January and February 7. Developing a Master Budget Heartbreaker Inc. manufactures...

    Prepare a production budget for January and February 7. Developing a Master Budget Heartbreaker Inc. manufactures a product with a selling price of $60 per unit. Units and monthly cost data follow: Variable: Selling and administrative............ Direct materials.............. Direct labor.. Variable manufacturing overhead...... Fixed: Selling and administrative....... Manufacturing (including depreciation of $11,000)............ $ 5 per unit sold 12 per unit manufactured 12 per unit manufactured 6 per unit manufactured $17,000 per month 34,000 per month Heartbreaker pays all bills in...

  • Decker Manufacturing is preparing its master budget for the first quarter of the upcoming year. The...

    Decker Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to deckers manufacturing s operation Current Assets as of December 31 (prior year): Cash 4600 Accounts receivable, net 47000 Inventory 15100 Property, plant, and equipment, net 123000 Accounts payable. 43000 Capital stock. 123500 Retained earnings. 23100 a. Actual sales in December were $71,000. Selling price per unit is projected to remain stable at $12 per unit throughout the budget period. Sales...

  • 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...

  • XX Ltd is preparing its budget for 2019. The company has collected the following information from...

    XX Ltd is preparing its budget for 2019. The company has collected the following information from the managers, 1. Sales: Sales for November 2018 Sales for December 2018 Expected sales for January 2019 Expected sales for February 2019 Expected sales for March 2019 Expected sales for April 2019 Expected sales for May 2019 Selling price per unit 112,500 102,100 113,000 112,500 116,000 125,000 137,500 $12 units units units units units units units The company likes to keep 15% of next...

  • Petrini Corporation makes one product and it provided the following information to help prepare the master budget for t...

    Petrini Corporation makes one product and it provided the following information to help prepare the master budget for the next four months of operations: a. The budgeted selling price per unit is $110. Budgeted unit sales for January, February, March, and April are 7,500, 10,600, 12,000, and 11,700 units, respectively. All sales are on credit. b. Regarding credit sales, 30% are collected in the month of the sale and 70% in the following month. c. The ending finished goods inventory...

  • The Master Budget 555 PROBLEMS Group A P9-54A Comprehensive budgeting problem (Le Damon Manufacturing is preparing...

    The Master Budget 555 PROBLEMS Group A P9-54A Comprehensive budgeting problem (Le Damon Manufacturing is preparing its master budget for the first que budgeting problem (Learning Objectives 2 & 3) ing year. The following data pertanto s preparing its master budget for the first quarter of the upcom- u facturing's operations Current Assets as of December 31 (prior year): Cash.. $ 4,600 Accounts receivable, net $ 46,000 Inventory $ 15,600 Property, plant, and equipment, net $121,000 Accounts payable. $ 43,000...

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