Concept explainers
(1)
Concept introduction:
Master
Sales forecast:
It relates to the monetary plan that shows the manner in which capital can be assigned in best way for achieving target for sales. The aim of this budget is to curb and plan for the expenditure incurred for objective achievement.
Sales forecast for the third quarter of the calendar.
Answer to Problem 4PSB
Therefore, it is determined that sales forecast for quarter first is $1020000.
Explanation of Solution
Sales forecast:
It relates to the monetary plan that shows the manner in which capital can be assigned in best way for achieving target for sales. The aim of this budget is to curb and plan for the expenditure incurred for objective achievement with respect to sales.
So, computation of sales forecast is given below.
N manufacturing forecast for sales | |||
Particulars | Forecasted units | Unit value | Dollar (total) |
July | 21000 | 17 | 357000 |
August | 19000 | 17 | 323000 |
September | 20000 | 17 | 340000 |
third quarter total | 60000 | 1020000 |
(2)
Concept introduction:
It depicts the units required to be produced. It is determined by a assembly of scheduled amount relating to stock of completed units and sales budget.
To explain:
Commodity production forecast (budget ) for the third quarter of the calendar.
Answer to Problem 4PSB
Therefore, it is determined that the production forecast (budget) for July, August and September is $17500, 19700 and $ 22800, respectively.
Explanation of Solution
It depicts the units required to be produced. It is determined by a assembly of scheduled amount relating to stock of completed units and sales budget.
Hence, computation of production budget as below,
N manufacturing production forecast (budget) | |||
Particulars | July | August | September |
Forecast sales for succeeding month | 19000 | 20000 | 24000 |
Ratio of stock to upcoming sales | 0.70 | 0.70 | 0.70 |
Forecasted closing stock | 13300 | 14000 | 16800 |
Add- forecasted sales | 19000 | 20000 | 24000 |
Units required to be manufactured | 34300 | 33000 | 36800 |
Less-opening stock | (16800) | (13300) | (14000) |
Units to be produced | 17500 | 19700 | 22800 |
(3)
Concept introduction:
Raw material forecast point out the forecast for the material that is required for producing of the units and services.
Raw material forecast for the third quarter of the calendar.
Answer to Problem 4PSB
Therefore, it is determined that the raw material forecast for the month of July, August and September is $50760, $81280 and $88800, respectively
Explanation of Solution
N manufacturing raw material forecast | |||
Particulars | July | August | September |
Manufactured forecasted units | 17500 | 19700 | 22800 |
Per unit material required | 0.50 | 0.50 | 0.50 |
Material required for manufacturing | 8750 | 9850 | 11400 |
Add-forecasted closing stock | 1970 | 2280 | 1980 |
Total material required | 10720 | 12130 | 13380 |
Less-opening stock | (4375) | (1970) | (2280) |
Material required to be purchased | 6345 | 10160 | 11100 |
Price per unit of material | $8 | $8 | $8 |
Cost in total of direct material (DM) purchase | 50760 | 81280 | 88800 |
(4)
Concept introduction:
Direct labour forecast usually determine the number hours required for producing units specified underlying the production forecast.
Direct labour forecast for the third quarter of the calendar.
Answer to Problem 4PSB
Therefore, it is determined that direct labour forecast for July, August and September is $140000, $157600 and $182400, respectively.
Explanation of Solution
Direct labour forecast usually determine the number hours required for producing units specified underlying the production forecast.
So, computation of direct labour forecast is given below.
N manufacturing labour(direct) forecast | |||
Particulars | July | August | September |
Forecasted manufacturing units | 17500 | 19700 | 22800 |
Requirement of labour unit per hours | 0.50 | 0.50 | 0.50 |
Total hours needed | 8750 | 9850 | 11400 |
Labour rate | 16 | 16 | 16 |
Labour $ | 140000 | 157600 | 182400 |
(5)
Concept introduction:
Factory
Factory overhead forecast for the third quarter of the calendar.
Answer to Problem 4PSB
Hence, it is determined that factory overhead forecast for July, August and September is $43625, $46595 and $50780, respectively.
Explanation of Solution
Factory overhead forecast is that forecast which consists of cost of production apart from cost relating to direct material (DM) and direct labour.
So, computation of factory overhead forecast is given below.
N manufacturing factory overhead forecast | |||
Particulars | July | August | September |
Hours of labour needed | 17500 | 19700 | 22800 |
Factory overhead (variable) rate | 1.35 | 1.35 | 1.35 |
Forecasted overhead(variable) | 23625 | 26595 | 30780 |
Overhead(fixed) | 20000 | 20000 | 20000 |
Total overhead forecasted | $43625 | $46595 | $50780 |
(6)
Concept introduction:
Forecast for selling expenses is that forecast which involves forecast relating to non producing department i.e. sales, marketing, engineering and accounting.
Selling expenses forecast for the third quarter of the calendar.
Answer to Problem 4PSB
Hence, it is determined that selling expenses forecast for July, August and September is $39200, $35800 and $37500, respectively.
Explanation of Solution
Forecast for selling expenses is that forecast that involves forecast relating to non producing department i.e. sales, marketing, engineering as well as accounting.
So computation of selling expenses forecast is given below.
N manufacturing selling expenses forecast | |||
Particulars | July | August | September |
Forecasted sales | 357000 | 323000 | 340000 |
Commission percentage sales | 10% | 10% | 10% |
Expenses related to sales commission | 35700 | 32300 | 34000 |
Salaries of sales | 3500 | 3500 | 3500 |
Selling expenses in total | $39200 | $35800 | $37500 |
(7)
Concept introduction:
Administrative and general expenditure forecast relates to those expenditure that are made for running of the company i.e. rent, utilities and insurance. It does not include expenditure that are in relation to manufacturing of the commodity and services.
Administrative and general expenses forecast for the third quarter of the calendar.
Answer to Problem 4PSB
Hence, it is determined that administrative and general expenses forecast for July, August and September is $11700, $11700 and $11700, respectively.
Explanation of Solution
Administrative and general expenditure forecast relates to those expenditure that are made for running of the company i.e. rent, utilities and insurance. It does not include expenditure that are in relation to manufacturing of the commodity and services.
So, computation of Administrative and general expenditure forecast is given below.
N manufacturing administrative and general expenses forecast | |||
Particulars | July | August | September |
Salaries | 9000 | 9000 | 9000 |
Long term interest |
2700 | 2700 | 2700 |
Expenses total | $11700 | $11700 | $11700 |
(8)
Concept introduction:
Cash received forecast shows the outflow and inflow of money(cash) on forecasted period to assess the money(cash) balance to meet the obligation of cash in forecasted period.
Cash forecast for the third quarter of the calendar.
Answer to Problem 4PSB
Therefore, the closing balance for July, August and September is $96835, $$141180 and $40000, respectively.
Explanation of Solution
Cash received forecast shows the outflow and inflow of money(cash) on forecasted period to assess the money(cash) balance to meet the obligation of cash in forecasted period.
So computation of cash received forecast is given below.
N manufacturing cash received forecast | |||
Particulars | July | August | September |
Total sales | 357000 | 323000 | 340000 |
Cash sales (30%) | 107100 | 96900 | 102000 |
Amount due from last month(70% of credit sales) | 249900 | 249900 | 226100 |
Total cash received | $357000 | $346800 | $328100 |
N manufacturing cash forecast | |||
Particulars | July | August | September |
Opening balance | 40000 | 96835 | 141180 |
Cash received | 357000 | 346800 | 328100 |
Total available cash | 397000 | 443635 | 469280 |
Cash disposal | |||
Payment for material | 51400 | 50760 | 81280 |
Payment for direct labour | 140000 | 157600 | 182400 |
Payment for overhead(variable) | 23625 | 26595 | 30780 |
Sales commission | 35700 | 32300 | 34000 |
Salaries | 3500 | 3500 | 3500 |
Administrative & general | 9000 | 9000 | 9000 |
Income tax | 10000 | ||
Dividends | 20000 | ||
Loan interest | 240 | ||
Interest long term | 2700 | 2700 | 2700 |
Purchase of equipment | 100000 | ||
Total cash disposal | 276165 | 302455 | 443660 |
Preliminary balance money(cash) | 120835 | 141180 | 25620 |
Additional loan | 14380 | ||
Payment of loan | (24000) | ||
Closing cash balance | $96835 | $141180 | $40000 |
Loan balance | $14380 |
(9)
Concept introduction:
Forecasted statement of income assess the financial standing of the company. It depicts the income, expenses, net income of a firm over a period.
Answer to Problem 4PSB
Hence it is determined that net revenue for third quarter is $7254.
Explanation of Solution
Forecasted statement of income assess the financial standing of the company. It depicts the income, expenses, net income of a firm over a period.
So, computation of income statement forecast is given below.
N manufacturing forecasted income statement | |||
sales | $1020000 | ||
Cost of goods sold(COGS) |
861000 | ||
Gross profit | 159000 | ||
Running expenses | |||
Commission on sales | 102000 | ||
Salaries | 10500 | ||
Administrative & general salaries | 27000 | ||
Long term interest | 8100 | ||
Expenses on interest | 240 | 147840 | |
Before tax income | 11160 | ||
Tax |
3906 | ||
Net revenue | $7254 |
Hence it is determined that net revenue for third quarter is $7254.
(10)
Concept introduction:
Financial statement also known as balance sheet that help in summarizing asset, liabilities and equity of the company held by shareholders at point of time.
Financial statement for the entire third quarter.
Answer to Problem 4PSB
Hence financial statement total for third quarter is $1054920.
Explanation of Solution
Financial statement also known as balance sheet that help in summarizing asset, liabilities and equity of the company held by shareholders at point of time.
So computation of financial statement forecast is given below.
N manufacturing forecasted income statement | |||
Asset | |||
Cash | 40000 | ||
Amount due | 238000 | ||
Raw material stock | 15840 | ||
Finished goods stock | 241080 | ||
Total current asset | 534920 | ||
Equipment | 820000 | ||
Less-depreciation | 300000 | 520000 | |
Total of asset | $1054920 | ||
Liabilities and equities | |||
Account to be paid | 88800 | ||
Bank loan | 14380 | ||
Taxes | 3906 | ||
Total of current liabilities | 107086 | ||
Long term loan | 300000 | ||
Common inventory | 600000 | ||
Retained income | 47834 | ||
Total equity shareholder | 647834 | ||
Total equity and liabilities | $1054920 |
Hence it is determined that total asset and liabilities is $1054920.
Want to see more full solutions like this?
Chapter 7 Solutions
MANAGERIAL ACCOUNTING FUND. W/CONNECT
- 19. A listing of the estimated balances in the company's ledger accounts as of December 31, 2023 is given below (as well as in your Excel template): Cash Accounts receivable Inventory-raw materials Inventory-finished goods Capital assets (net) Assets $ 83,365 1,122,900 10,000 9,125 724,000 $1,949,390 Total assets Liabilities and Shareholders' Equity Accounts payable $ 231,563 Capital stock 1,000,000 Retained Earnings Total liabilities and shareholders' equity 717,828 $1,949,390 Required: 1. Prepare a monthly master budget for ToyWorks for the year ended December 31, 2024, including the following schedules (Use the Excel template provided!): Sales Budget & Schedule of Cash Receipts Production Budget & Manufacturing Overhead Budget Direct Materials Budget & Schedule of Cash Disbursements Direct Labour Budget Selling and Administrative Expense Budget Ending Finished Goods Inventory Budget Cash Budget 2. Prepare budgeted financial statements at December 31, 2024, using absorption costing.arrow_forwardPresented below are selected accounts of Yasunari Kawabata Company at December 31, 2020. Inventory (finished goods) $ 52,000 Cost of Goods Sold $2,100,000 Unearned Service Revenue 90,000 Notes Receivable 40,000 Equipment 253,000 Accounts Receivable 161,000 Inventory (work in process) 34,000 Inventory (raw materials) 207,000 Cash 37,000 Supplies Expense 60,000 Debt Investments (trading) 31,000 Allowance for Doubtful Accounts 12,000 Customer Advances 36,000 Licenses 18,000 Restricted Cash for Plant Expansion 50,000 Additional Paid-in Capital 88,000 Treasury Stock 22,000 The following additional information is available. 1. Inventories are valued at lower-of-cost-or-market using LIFO. 2. Equipment is recorded at cost. Accumulated depreciation, computed on a straight-line basis, is $50,600. 3. The short-term investments have a fair value of $29,000. 4. The notes receivable are due April 30, 2022, with interest receivable every April 30. The…arrow_forwardABC company's records included the following, assume 365 days in a year: Accounts Receivable, 12/31/20 $ 860,000 Accounts Receivable, 12/31/19 780,000 Merchandise Inventory, 12/31/20 900,000 800,000 Merchandise Inventory, 12/31/19 Net Sales during 2020 8,364,000 Cost of Sales during 2020 5,950,000 Compute Solomon's accounts receivable turnover ratio in 2020 O 9.8 times O 10.7 times O 10.2 times 9.73 timesarrow_forward
- Presented below are selected accounts of Novak Company at December 31, 2017. Inventory (finished goods) $ 53,500 Cost of Goods Sold $2,192,400 Unearned Service Revenue 95,200 Notes Receivable 41,000 Equipment 257,100 Accounts Receivable 161,020 Inventory (work in process) 36,000 Inventory (raw materials) 182,280 Cash (not including restricted cash) 43,800 Supplies Expense 65,490 Debt Investments (trading) 39,500 Allowance for Doubtful Accounts 11,290 Customer Advances 53,200 Licenses 16,890 Restricted Cash for Plant Expansion 58,300 Additional Paid-in Capital 88,040 Treasury Stock 22,320 The following additional information is available. 1. Inventories are valued at lower-of-cost-or-market using LIFO. 2. Equipment is recorded at cost. Accumulated depreciation, computed on a straight-line basis, is $47,568. 3. The short-term investments have a fair value of $29,730. 4. The notes receivable are due April 30, 2019, with interest receivable every April 30. The notes bear interest at 6%.…arrow_forwardThe following are selected ledger accounts of Spock Corporation at December 31, 2020. Cash $ 185,000 Salaries and wages expense (sales) $284,000 Inventory 535,000 Salaries and wages expense (office) 346,000 Sales revenue 4,275,000 Purchase returns 15,000 Unearned sales revenue 117,000 Sales returns and allowances 79,000 Purchases 2,786,000 Freight-in 72,000 Sales discounts 34,000 Accounts receivable 142,500 Purchase discounts 27,000 Sales commissions 83,000 Selling expenses 69,000 Telephone and Internet expense (sales) 17,000 Accounting and legal services 33,000 Utilities expense (office) 32,000 Insurance expense (office) 24,000 Miscellaneous office expenses 8,000 Advertising expense 54,000 Rent revenue 240,000 Delivery expense 93,000 Casualty loss (before tax) 70,000 Depreciation expense (office equipment) 48,000 Interest expense 176,000 Depreciation expense (sales equipment)…arrow_forwardSelected information from the comparative financial statements of AppleVerse Company for the year ended December 31 appears below: 2018 2017 Php Php Accounts receivable (net) 175,000 200,000 Inventory 130,000 150,000 Total assets 1,100,000 800,000 Current liabilities 140,000 110,000 Long-term debt 410,000 300,000 Net credit sales 800,000 700,000 Cost of goods sold 600,000 530.000 Interest expense 40.000 25,000 Income tax expense 60.000 29,000 Net income 150.000 85,000 Net cash provided by operating 220,000 135,000 activities Compute for the Receivables Turnover for 2018. O 2.13 O 4.27 O 5.95 O 3.23arrow_forward
- The financial information below was taken from the annual financial statements of Cullumber Videos: 2014 2013 Current assets $99,800 $101,200 Current liabilities 36,800 51,200 Total liabilities 158,000 168,800 Total assets 441,000 476,000 Net sales 473,800 512,000 Net credit sales 466,000 500,000 Cost of goods sold 262,000 264,000 Inventory 46,000 44,800 Receivables (net) 26,800 24,800 Dividends 7,600 10,400 Capital expenditures 13,400 19,200 Net income 45,200 36,800 Net cash provided by operating activities 28,600 35,200 Calculate the following ratios for Cullumber Videos for 2014. (Round Free cash flow to 0 decimal place, e.g. 12. Other all answers to 2 decimal places, e.g. 12.21.) 1. Average collection period enter a number of days rounded to 2 decimal places days 2. Current ratio enter…arrow_forwardThe financial information below was taken from the annual financial statements of Cullumber Videos: 2014 2013 Current assets $99,800 $101,200 Current liabilities 36,800 51,200 Total liabilities 158,000 168,800 Total assets 441,000 476,000 Net sales 473,800 512,000 Net credit sales 466,000 500,000 Cost of goods sold 262,000 264,000 Inventory 46,000 44,800 Receivables (net) 26,800 24,800 Dividends 7,600 10,400 Capital expenditures 13,400 19,200 Net income 45,200 36,800 Net cash provided by operating activities 28,600 35,200 Calculate the following ratios for Cullumber Videos for 2014. (Round Free cash flow to 0 decimal place, e.g. 12. Other all answers to 2 decimal places, e.g. 12.21.) What is the free cash flow?arrow_forwardMissoula Inc. reported the following selected financial statement data: Dec 31, 2020 Dec 31, 2021Cash $ 38,000 $ 44,000 Accounts receivable (net) 56,000 68,000 Inventory 76,000 80,000 Plant assets (net) 218,000 234,000 Total assets 429,000 411,000 Liabilities 153,000 153,000 Shareholders' equity 276,000 258,000 Net sales 348,000 848,000 Cost of goods sold 228,000 312,000 Net income 28,000 41,000 Required:Compute the asset turnover ratio for 2021.arrow_forward
- The financial information below was taken from the annual financial statements of Cullumber Videos: 2014 2013 Current assets $99,800 $101,200 Current liabilities 36,800 51,200 Total liabilities 158,000 168,800 Total assets 441,000 476,000 Net sales 473,800 512,000 Net credit sales 466,000 500,000 Cost of goods sold 262,000 264,000 Inventory 46,000 44,800 Receivables (net) 26,800 24,800 Dividends 7,600 10,400 Capital expenditures 13,400 19,200 Net income 45,200 36,800 Net cash provided by operating activities 28,600 35,200 Calculate the following ratios for Cullumber Videos for 2014. (Round Free cash flow to 0 decimal place, e.g. 12. Other all answers to 2 decimal places, e.g. 12.21.) 1. Average collection period enter a number of days rounded to 2 decimal places days 2. Current ratio enter…arrow_forwardThe 2021 income statement of Adrian Express reports sales of $14,400,000, cost of goods sold of $8,387,500, and net income of $1,550,000. Balance sheet information is provided in the following table. ADRIAN EXPRESSBalance SheetsDecember 31, 2021 and 2020 2021 2020 Assets Current assets: Cash $ 550,000 $ 710,000 Accounts receivable 1,300,000 950,000 Inventory 1,700,000 1,350,000 Long-term assets 4,750,000 4,190,000 Total assets $ 8,300,000 $ 7,200,000 Liabilities and Stockholders' Equity Current liabilities $ 1,970,000 $ 1,610,000 Long-term liabilities 2,250,000 2,350,000 Common stock 1,900,000 1,900,000 Retained earnings 2,180,000 1,340,000 Total liabilities and stockholders' equity $ 8,300,000 $ 7,200,000 Industry averages for the following four risk ratios are as follows:…arrow_forwardABC company's records included the following, assume 365 days in a year: Accounts Receivable, 12/31/20 $ 860,000 Accounts Receivable, 12/31/19 780,000 Merchandise Inventory, 12/31/20 900,000 Merchandise Inventory, 12/31/19 Net Sales during 2020 Cost of Sales during 2020 800,000 8,364,000 5,950,000 What is the average collection period, in days, for Solomon's accounts receivable O 35.8 days O 36.3 days O 34.1 days 37.5 daysarrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education