Estimated Production units | |||||
Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Total for 2021 | |
Units sold | 260,000 | 240,000 | 280,000 | 300,000 | 1,080,000 |
Add: ending finished goods inventory | 135,000 | 135,000 | 135,000 | 135,000 | 135,000 |
Units available for sale | 395,000 | 375,000 | 415,000 | 435,000 | 1,215,000 |
Less: Beginning finished goods inventory | 100,000 | 135,000 | 135,000 | 135,000 | 100,000 |
Units Produced | 295,000 | 240,000 | 280,000 | 300,000 | 1,115,000 |
Units Produced | 295,000 | 240,000 | 280,000 | 300,000 | |
Multiply: Direct labor hour per unit | 0.02 | 0.02 | 0.02 | 0.02 | |
Direct labor hours required (DLH) | 5,900 | 4,800 | 5,600 | 6,000 |
Overhead budget | |||||
Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Total for 2021 | |
Direct labor hours required (DLH) | 5,900 | 4,800 | 5,600 | 6,000 | |
Indirect materials | $4,425 | $3,600 | $4,200 | $4,500 | $16,725 |
Electricity | $11,800 | $9,600 | $11,200 | $12,000 | $44,600 |
Maintenance on machine | $2,950 | $2,400 | $2,800 | $3,000 | $11,150 |
Supervisor's salary (Fixed cost) | $72,000 | $72,000 | $72,000 | $72,000 | $288,000 |
Factory rent (Fixed cost) | $85,000 | $85,000 | $85,000 | $85,000 | $340,000 |
Insurance (Fixed cost) | $14,000 | $14,000 | $14,000 | $14,000 | $56,000 |
Machinery depreciation (Fixed cost) | $16,000 | $16,000 | $16,000 | $16,000 | $64,000 |
Total overhead | $206,175 | $202,600 | $205,200 | $206,500 | $820,475 |
Selling and administration budget | |||||
Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Total for 2021 | |
Units sold | 260,000 | 240,000 | 280,000 | 300,000 | |
Freight and delivery costs | $1,040,000 | $960,000 | $1,120,000 | $1,200,000 | $4,320,000 |
Advertising costs | $20,000 | $20,000 | $20,000 | $20,000 | $80,000 |
Office salaries | $40,000 | $40,000 | $40,000 | $40,000 | $160,000 |
Rent on Admin. building | $25,000 | $25,000 | $25,000 | $25,000 | $100,000 |
Insurance expenses | $5,000 | $5,000 | $5,000 | $5,000 | $20,000 |
Depreciation on office expense | $5,000 | $5,000 | $5,000 | $5,000 | $20,000 |
Total selling and administration | $1,135,000 | $1,055,000 | $1,215,000 | $1,295,000 | $4,700,000 |
Question: Materials e) Overhead budget (4 marks) f) Selling and administrative expenses budget (4 marks) Fizzy...
question 1
material
c) Direct materials purchases budget (9 marks) Fizzy Pop bottles a lemon flavoured soft drink. All inventory is in direct materials and finished goods at the end of each quarter. There is no work-in-process inventory. Fizzy Pop uses cases as the unit of analysis in its budgeting. Each case contains 24 bottles. The business is preparing to build its master budget for the next financial year ending 31 December 2021. The master budget will be based on...
Question Material
g) Ending finished goods inventory budget (3 marks) h) Cost of goods sold budget (4 marks) Fizzy Pop bottles a lemon flavoured soft drink. All inventory is in direct materials and finished goods at the end of each quarter. There is no work-in-process inventory. Fizzy Pop uses cases as the unit of analysis in its budgeting. Each case contains 24 bottles. The business is preparing to build its master budget for the next financial year ending 31 December...
PREVIOUS PROBLEM!
40. Selling and Administrative Budget and Budgeted Income Statement. CThe previous problem must be completed before working this problem.) Sports Bars, Inc., produces energy bars. Management estimates all selling and administrative costs are fixed. Quarterly selling and administrative cost estimates for the coming year follow Salaries Rent Advertising $120,000 Depreciation 75,000 Other $170,000 $ 65,000 36,000 Required: a Use the information presented previously to prepare a selling and administrative budget. Refer to the format shown in Figure 9.8....
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...
repare the selling and administrative expense budget. WILDHORSE FARM SUPPLY COMPANY Selling and Administrative Expense Budget For the Six Months Ending June 30, 2020 V Quarter Six Months Sales 28400 42600 71000 Variable Expenses 259860 649650 389790 176000 649650 176000 X Fixed Expenses 176000 176000 Total Selling and Administrative Expenses v 435860 $ 565790 825650 Click if you would like to Show Work for this question: Open Show Work Question 5 Wildhorse Farm Supply Company manufactures and sells a pesticide...
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:...
NEED ANSWER OF THE " F " PART ONLY!
39. Budgeting for Sales, Production, Direct Materials, Direct Labor, and Manufacturing Overhead. Sports Bars Inc., produces energy bars and sells them by the case (1 unit - 1 case). Information to be used for the operating budget this coming year follows: Average sales price for each case is estimated to be $25. Unit sales for this coming year, ending December 31, are expected to be as follows First quarter 80,ooo Second...
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...
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...
Sales (500,000 units) Costs and expenses Direct materials Direct labor Overhead Selling expenses Administrative expenses Total costs and expenses Net income $7,500.888 1,000,000 2,000,000 see,eee 750.800 1,285.cee 5.535.000 $1,965,000 The company has an opportunity to sell 50,000 additional units at $13 per unit. The additional sales would not affect its current expected sales. Direct materials and labor costs per unit would be the same for the additional units as they are for the regular units. However, the additional volume would...