ZuoTi.Pro
Question

create the initial documents for the master budget:

• sales budget

• production budget

• direct materials purchases budget

• direct labor budget

• overhead budget

• selling and administrative expense budget

• cash budget include a schedule of cash collections and payments

• finished goods inventory calculation

Then, Create the following schedules, financial statements, and calculations
A) Pro forma cost of goods manufactured

B) Pro forma Cost of goods sold- both financial and variable cost basis

C) Pro forma income statement (financial basis)

D) Pro forma balance sheet

E)Pro forma Income statement (variable cost basis)

F) Pro forma statement of retained earnings

G) breakeven analysis: 1. breakeven sales level in units and dollars. 2. cost volume profit graph showing the breakeven point

H) Flexible Budget

1. Create the flecxible budget results for production costs as if actual production were 160,000 units in the first quarter of 2019

2. Add flexible budget results for slightly higher and slightly lower production at 170,000 units and 150,000 units, respectively.

Raw Materials 3 direct material units per finished good production unit 84.25 per raw material unit Variable Overhead 9.50 per Direct Labor Hour Fixed Overhead Depreciation Other Fixed Overhead 326,000 per quarter $915,000 per quarter Fixed Overhead Application Rate CALCULATE FROM PRODUCTION BUDGET NTORY ACCOUNTS 4th 2nd Quarter 4th 1st Quarter Ending Finished Goods Inventory in units Quarter Quarter Quarter 0 15,500 19,000 19,500 15,000 Raw Materials Inventor Beginning Inventory 1/1/2020 Planned Ending Inventory 28,436 units 26,000 units Policy 25% of next quarters needs for production is in ending Raw Materials Inventory Work In Process Inventory Beginning Inventory 1/1/2020 Planned Ending Inventory 2,850 2,850

Payment for Raw Materials 85% quarter of purchase 15% quarterfollowing purchase Payment Policy + OPERATING EXPENSES Wages and Salaries Payment Payment Policy 2 times monthly on the 15th and 30th Fully paid each month Variable Selling & Administrative Exp 3.50% of selling price Fixed Selling& Administrative Exp Depreciation Other Selling & Administrative Exp $55,000 per quarter $180,000 per quarter CAPITAL EXPENDITURES Equipment Purchases $5,450,000 end of 4th quarter TREASURY ACTIVITIES Dividends to be Declared $400,000 per quarter Minimum Cash Balance $250,000 Required at end of every quarter Interest Rate for Investing (short-term) 3.50% Annually Interest Policy All of the ending cash balance for the quarter earns interest for the entire quarter

Interest Rate for Investing (short-term) 3.50% Annually Interest Policy All of the ending cash balance for the quarter earns interest for the entire quarter All of the ending cash balance for the quarter remains in Cash at the beginning of the next quarter Interest Rate for borrowing 12% Annually Interest Policy $10,000 increments are used in borrowing and repayment, maintaining the minimum cash balance Borrowing occurs at the beginning of the quarter Repayments occur at the end of the iquarter FLEXIBLE BUDGET Actual Units Produced First Quarter 43,000 units (use for Flexible Budget Tab only) Flexible Budget - Analyze at 2 Production Levels Production level 1 Production level 2 45,000 units 35,000 units PRIOR YEAR RESULTS PSC Industries Balance Sheet 12/31/2018 ASSETS Cash Inventory Accounts Receivable (net) Plant and Equipment 6,150,000 3,748,000 5,050,000 29,400,000

LIABILITIES AND EQUITY Accounts Payable Common Stock Retained Earnings 8,100,000 26,234,500 $ 10,013,500 44,348,000

Here is the template for everything

Sales Budget Projected for Year Ending 12/31/2019 First Second Third Fourth Annual Quarter Quarter Quarter Quarter Total Sales in Units Selling Price Sales Revenue 31,000 $530 $ 19,769,000 | 18,285,000$ 16,430,000 37,300 34,500 43,000 145800 $530 $530 $530 530 22,790,000$ 77,274,000 $77,274,000 Checkfigure from Total COLULMN NOTE: this information flows into the Cash Collections portion of the Cash Budget 4 5

Production Budget i.e. Finished Goods Production Plan First Second Third Fourth Annual Quarter Quarter Quarter Quarter Total Sales needs (Production Units) Ending Inventory 37,300 15,500 52,800 34,500 19,000 53,500 31,000 19,500 50,500 43,000 15,000 58,000 145,800 15,000 160,800 Total Needs Beginning Inventory Total Production 160,800 Checkfigure for Annual Total Column

Direct Materials Purchases Budget First Quarter Second Quarter Third Quarter Fourth Quarter Annual Total Finished Goods Produced (units DM needed per unit DM needed for production DM Ending Inventory Units Total DM needed DM Beginning Inventory DM Purchases in Units Purchase Cost per Unit Cost of DM Purchases DM Direct Materials (i.e. raw materials) Direct Labor Budget First Quarter Second Quarter Third Quarter Fourth Quarter Annual Total FG Units to be Produced Hours Required/Unit Total Hours Required Hourly Labor Rate Direct Labor Cost FG Finished Goods or production units

Overhead Budget Leave Totals rounded to nearest dollar First Quarter Second Quarter Third Quarter Fourth Quarter Annual Total Budgeted Hours Variable Overhead Rate (S/hour) Budgeted Variable Overhead Budgeted Fixed Overhead without Depreciation Depreciation 0 Total Overhead SO Selling & Administrative Expense Bud Leave Totals rounded to nearest dollar First Quarter Second Quarter Third Quarter Fourth Quarter Annual Total Planned Sales in Dollars Variable S&A rate (% Per Unit Sold) 1Variable S&A Expense Fixed S&A Expense without depreciation Depreciation 4Total S&A Expense S0

SCHEDULE OF CASH COLLECTIONS First Fourth Quarter Second Third Quarter Annual Quarter Quarter Credit Sales Collected quarter of sale Collected quarter following sale Total Collections Net Accounts Receivable Balance SCHEDULE OF CASH PAYMENTS First Quarter Second Third Fourth Quarter Annual Quarter Quarter Purchases this quarter Payments for this quarters purchases Payments for last quarters purchases al nav

Total payments Accounts payable balance CASH BUDGET First Quarter Third Quarter Fourth Quarter Annual Second Quarter Beginning Cash Balance Cash Collections: From credit sales current quarter previous quarter Total Cash Available Cash Disbursements: For Raw Materials - Current quarter, paid for Previous quarter, paid for Direct Labor Overhead Selling and Administrative Expense

Equipment Purchases Dividends Total Cash Disbursements Actual cash balance Minimum cash balance Excess (Deficiency) of Cash Leave Financing section empty: Financing: (should not be required) Interest Total Financing Cash Increase (Decrease) Cash Balance before interest on balance Interest Earned on Cash Balance Cash Balance after interest on balance Grayed cells are not used

Cost of Goods Manufactured - Absorption For Year Ended 12/31/2019 Grayed cells not used Direct Materials: Beginning Inventory Direct Material Purchases Direct Materials Available Ending Inventory Direct Materials Used Direct Labor: Overhead Total Manufacturing Costs Added Plus: Beginning Work in Process Inventory Total Manufacturing Costs Less: Ending Work in Process Inventory Cost of Goods Manufactured Cost of Goods Manufactured - Variable For Year Ended 12/31/2019 Direct Materials Used Direct Labor Variable Overhead Total Variable Manufacturing Costs

Cost of Goods Sold Absorption Note FG beginning Inventory is on Input Tab Finished Goods Beginning Inventory Cost of Goods Manufactured Finished Goods Ending Inventory Cost of Goods Sold Cost of Goods Sold - Variable Finished Goods Beginning Inventory Cost of Goods Manufactured Finished Goods Ending Inventory Cost of Goods Sold

PSC Industries Grayed cells not used Absorption Costing Income Statement For the Year Ended 12/31/2019 Revenue Less: Cost of Goods Sold Gross Margin Less: Operating Expenses Selling & Administrative Expense Bad Debt Expense Operating Income Plus: Interest Revenue Income Before Taxes

PSC Industries Variable Costing Income Statement For the Year Ended 12/31/2019 Grayed cells not used Revenue Less: Variable Costs Variable Cost of Goods Sold Variable Selling & Administrative Bad Debt Expense Contribution Margin Less: Fixed Costs Fixed Manufacturing Cost Fixed Selling & Administrative Operating Income Plus: Interest Revenue Income Before Taxes

PSC Industries Absorption Costing Income Statement For the Year Ended 12/31/2019 Retained Earnings 12/31/18 Plus: Net Income Less: Dividends Retained Earnings 12/31/19

Breakeven Analysis Variable Cost Per Unit Quantity trie hours per unit units of DM per unit DL hours per unit percentage of sales price percentage of sales price DL DM Var OH S&A Bad Debts Var. Costs/unit Model Information Per Unit Selling Price Variable Costs Contribution Margin Total Fixed Expense Fixed S & A Fixed Overhead Total Fixed Cost

5 Breakeven: units 9Table of Information for Graph showing Breakeven Point Total Cost Revenue 0 4,000 林.XX) 12,000 16,000 20,000 28,000 32,000 36,000 48,000 52,000 56,000 64,000

Flexible Budget Production Costs Grayed cells not used Actual Production Flexible Flexible Budget Budget Unit Costs Level Level 1 Level 2 Budgeted Production Cost: Direct Materials Direct Labor Variable Overhead Total Variable Production Cost Fixed Cost Total Budgeted Production Cost

business   accounting   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Solution:

Part 1 – Production Budget

Production Budget

First Quarter

Second Quarter

Third Quarter

Fourth Quarter

Annual

Sales needs (Production units)

37300

34500

31000

43000

145800

Plus: Desired Ending Finished Goods Inventory

15500

19000

19500

15000

15000

Total Needs

52800

53500

50500

58000

160800

Less: Estimated Beginning Finished Goods Inventory

0

15500

19000

19500

0

Required Production in Units

52800

38000

31500

38500

160800

Part 2 – Direct materials purchase budget

Raw Materials Budget

First quarter

Second quarter

Third Quarter

Fourth Quarter

Annual

Finished goods produced (units)

52,800

38,000

31,500

38,500

160,800

DM needed per unit

3

3

3

3

3

Direct materials needed for production

158400

114000

94500

115500

482400

Plus: Desired Raw Material Ending Inventory (25% of next month's production needs)

28500

23625

28875

26000

26000

Total direct materials needed

186900

137625

123375

141500

508400

Less: Estimated Beginning Raw materials Inventory

28436

28500

23625

28875

28436

Budgeted Raw Materials purchases in units

158464

109125

99750

112625

479964

Direct materials cost per unit

$84.25

$84.25

$84.25

$84.25

$84.25

Budgeted cost of direct materials

$13,350,592.00

$9,193,781.25

$8,403,937.50

$9,488,656.25

$40,436,967.00

Part 3 – Direct labor budget

Direct Labor Budget

Quarter 1

Quarter 2

Quarter 3

Quarter 4

Annual

FG Units to be produced

52,800

38,000

31,500

38,500

Required Direct Labor Hour per unit

4.50

4.50

4.50

4.50

Total Direct Labor Hours Required

237,600

171,000

141,750

173,250

Direct Labor Cost per hour

$19.5

$19.5

$19.5

$19.5

Budgeted Direct Labor Cost

$4,633,200

$3,334,500

$2,764,125

$3,378,375

$14,110,200

Part 4 – Overhead Budget

Overhead Budget

First quarter

Second quarter

third quarter

fourth quarter

Annual

Budgeted Hours

237600

171000

141750

173250

Variable overhead rate ($/Hour)

$9.50

$9.50

$9.50

$9.50

Budgeted Variable Overhead

$2,257,200

$1,624,500

$1,346,625

$1,645,875

Budgeted Fixed Overhead without Depreciation

$915,000

$915,000

$915,000

$915,000

Depreciation

$326,000

$326,000

$326,000

$326,000

Total Overhead

$3,498,200

$2,865,500

$2,587,625

$2,886,875

$11,838,200

Hope the above calculations, working and explanations are clear to you and help you in understanding the concept of question.... please rate my answer...in case any doubt, post a comment and I will try to resolve the doubt ASAP…thank you

Pls ask separate question for remaining parts

0 0
Add a comment
Know the answer?
Add Answer to:
create the initial documents for the master budget: • sales budget • production budget • direct...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

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

  • Create These budgets: -selling and administrative expense budget -cash budget include a schedule of cash collections...

    Create These budgets: -selling and administrative expense budget -cash budget include a schedule of cash collections and payments -finished goods inventory calculation Then, Create the following schedules, financial statements, and calculations A) Pro forma cost of goods manufactured B) Pro forma Cost of goods sold- both financial and variable cost basis C) Pro forma income statement (financial basis) D) Pro forma balance sheet E)Pro forma Income statement (variable cost basis) F) Pro forma statement of retained earnings G) breakeven analysis:...

  • Please prepare a production budget with the following master budget information: Projected unit sales for each...

    Please prepare a production budget with the following master budget information: Projected unit sales for each quarter for 2013 are as follows: Quarter 1            60,000 Quarter 2            70,000 Quarter 3            80,000 Quarter 4            65,000 The selling price is $500 per unit. All sales are on credit (no cash sales). 70% of all sales are collected within the quarter they are sold. The other 30% are collected in the following quarter. There are no bad debts. There is no beginning inventory...

  • Operating Budget, Comprehensive Analysis Allison Manufacturing produces a subassembly used in the production of jet aircraft...

    Operating Budget, Comprehensive Analysis Allison Manufacturing produces a subassembly used in the production of jet aircraft engines. The assembly is sold to engine manufacturers and aircraft maintenance facilities. Projected sales in units for the coming 5 months follow: January 40,000 February 50,000 March 60,000 April 60,000 May 62,000 The following data pertain to production policies and manufacturing specifications followed by Allison Manufacturing: Finished goods inventory on January 1 is 32,000 units, each costing $166.06. The desired ending inventory for each...

  • CHAPTER 8! MASTER DUDUL IN-CLASS PRACTICE PROBLEM - SALES BUDGET TO MANUFACTURING OVERHEAD BUDGET (SCHEDULES 1-10)...

    CHAPTER 8! MASTER DUDUL IN-CLASS PRACTICE PROBLEM - SALES BUDGET TO MANUFACTURING OVERHEAD BUDGET (SCHEDULES 1-10) The following information pertains to the budgeting process for Tulip, Inc. SALES: Tulip, Inc. sell one type of decorative basket for $25 per basket. Based on various sales forecasting models, Tulip expects to sell 11.000 units in quarter 1. 10,000 in quarter 2, 12,000 in quarter 3 and 9,000 in quarter 4. The beginning accounts receivable balance was $58,000. Assuming all sales are made...

  • SarasotaCompany is preparing its master budget for 2017. Relevant data pertaining to its sales, production, and...

    SarasotaCompany is preparing its master budget for 2017. Relevant data pertaining to its sales, production, and direct materials budgets are as follows. Sales. Sales for the year are expected to total 1,200,000 units. Quarterly sales are 18%, 25%, 23%, and 34%, respectively. The sales price is expected to be $38 per unit for the first three quarters and $47 per unit beginning in the fourth quarter. Sales in the first quarter of 2018 are expected to be 10% higher than...

  • preparing a master budget practice Schedules to include: a. Sales Budget, with a Schedule of Expected Cash Coll...

    preparing a master budget practice Schedules to include: a. Sales Budget, with a Schedule of Expected Cash Collections b. Production Budget C. Ending Finished Goods Inventory Budget d. Direct Materials Budget, with a Schedule of Cash Disbursement e. Direct Labor Budget f. Manufacturing Overhead Budget g. Selling & Administrative Expense Budget h. Cash Budget i. Budgeted Income Statement Sharp Products is a manufacturing company. It uses absorption costing for budgeting. amount unit Budgeted sales: Q1 of 2019 23,000 cases Q2...

  • Operating Budget, Comprehensive Analysis Allison Manufacturing produces a subassembly used in the production of jet aircraft...

    Operating Budget, Comprehensive Analysis Allison Manufacturing produces a subassembly used in the production of jet aircraft engines. The assembly is sold to engine manufacturers and aircraft maintenance facilities. Projected sales in units for the coming 5 months follow: January 40,000 February 50,000 March 60,000 April 60,000 May 62,000 The following data pertain to production policies and manufacturing specifications followed by Allison Manufacturing: 1 a. Finished goods inventory on January 1 is 32,000 units, each costing $166.06. The desired ending inventory...

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

    SalesUnit sales for November 2019114,000Unit sales for December 2019103,000Expected unit sales for January 2020114,000Expected unit sales for February 2020111,000Expected unit sales for March 2020116,000Expected unit sales for April 2020125,000Expected unit sales for May 2020136,000Unit selling price$12Waterways likes to keep 10% of the next month’s unit sales in ending inventory. All sales are on account. 85% of the Accounts Receivable are collected in the month of sale, and 15% of the Accounts Receivable are collected in the month after sale. Accounts...

  • Operating Budget, Comprehensive Analysis Ponderosa, Inc., produces wiring harness assemblies used in the production of semi-trailer...

    Operating Budget, Comprehensive Analysis Ponderosa, Inc., produces wiring harness assemblies used in the production of semi-trailer trucks. The wiring harness assemblies are sold to various truck manufacturers around the world. Projected sales in units for the coming five months are given below. January 10,000 February 10,500 March 13,100 April 16,000 May 18,500 The following data pertain to production policies and manufacturing specifications followed by Ponderosa: Finished goods inventory on January 1 is 900 units. The desired ending inventory for each...

  • Okay Company is preparing to build its master budget. The budget will detail each quarter's activity and the activity for the year in total.

    Master Budget ProjectOkay Company is preparing to build its master budget. The budget will detail each quarter's activity and the activity for the year in total. The master budget will be based on the following information:a. This will be the first year of operation for Okay Company.b. Budgeted unit sales by quarter for 2017 are projected as follows: First quarter 6,300 , Second quarter 6,100 , Third quarter 6,100 & Fourth quarter 6,450 . First and second quarter 2018 budgeted...

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