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: 1. breakeven sales level in units and dollars. 2. cost volume profit graph showing the breakeven point
H) Flexible Budget 1. Create the flexible 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.
Here are the numbers:
Here are the templates:
Selling and administrative expense budget | |||||
Overhead Budget | |||||
First Quarter | Second Quarter | Third Quarter | Fourth Quarter | Annual Total | |
Budgeted Hours (Budgeted Sales*4.5 hours) | 167850 | 155250 | 139500 | 193500 | |
Variable Overhead rate/Hour | $ 9.50 | $ 9.50 | $ 9.50 | $ 9.50 | |
Budgetede Variable Overhead | $ 1,594,575 | $ 1,474,875 | $ 1,325,250 | $ 1,838,250 | $ 6,232,950 |
Budgetede Fixed Overhead Withour Depreciation | $ 915,000 | $ 915,000 | $ 915,000 | $ 915,000 | $ 3,660,000 |
Total Overhead | $ 2,509,575 | $ 2,389,875 | $ 2,240,250 | $ 2,753,250 | $ 9,892,950 |
Create These budgets: -selling and administrative expense budget -cash budget include a schedule of cash collections...
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...
Need Selling & Administrative Expense Budget, Cash Budget, Budgeted Income Statement for EXCEL. 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...
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...
Assistance needed!!! The Diesel Dynamo Company is a high-tech diesel subsystem production business that produces technology accessories for trucks and other transport. The design of Diesel Dynamo products are unique and represent a breakthrough in the industry. The units Diesel Dynamo produces claim to provide for greater dependability, quality and longevity. The company is completing its third year of operations and is preparing to create a master budget for next year, 2017. The budget will detail each quarter’s activities and...
Please help!!! The Diesel Dynamo Company is a high-tech diesel subsystem production business that produces technology accessories for trucks and other transport. The design of Diesel Dynamo products are unique and represent a breakthrough in the industry. The units Diesel Dynamo produces claim to provide for greater dependability, quality and longevity. The company is completing its third year of operations and is preparing to create a master budget for next year, 2017. The budget will detail each quarter’s activities and...
Any help would be greatly appreciated! The Diesel Dynamo Company is a high-tech diesel subsystem production business that produces technology accessories for trucks and other transport. The design of Diesel Dynamo products are unique and represent a breakthrough in the industry. The units Diesel Dynamo produces claim to provide for greater dependability, quality and longevity. The company is completing its third year of operations and is preparing to create a master budget for next year, 2017. The budget will detail...
Need Help!!! The Diesel Dynamo Company is a high-tech diesel subsystem production business that produces technology accessories for trucks and other transport. The design of Diesel Dynamo products are unique and represent a breakthrough in the industry. The units Diesel Dynamo produces claim to provide for greater dependability, quality and longevity. The company is completing its third year of operations and is preparing to create a master budget for next year, 2017. The budget will detail each quarter’s activities and...
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...
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...
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...