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- |
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 W/CONNECT >IC<
- The following selected information is taken from the financial statements of Arnn Company for its most recent year of operations: During the year, Arnn had net sales of 2.45 million. The cost of goods sold was 1.3 million. Required: Note: Round all answers to two decimal places. 1. Compute the current ratio. 2. Compute the quick or acid-test ratio. 3. Compute the accounts receivable turnover ratio. 4. Compute the accounts receivable turnover in days. 5. Compute the inventory turnover ratio. 6. Compute the inventory turnover in days.arrow_forwardJuroe Company provided the following income statement for last year: Juroes balance sheet as of December 31 last year showed total liabilities of 10,250,000, total equity of 6,150,000, and total assets of 16,400,000. Required: Note: Round answers to two decimal places. 1. Calculate the times-interest-earned ratio. 2. Calculate the debt ratio. 3. Calculate the debt-to-equity ratio.arrow_forwardMillennial Manufacturing has net credit sales for 2018 in the amount of $1,433,630, beginning accounts receivable balance of $585,900, and an ending accounts receivable balance of $621,450. Compute the accounts receivable turnover ratio and the number of days sales in receivables ratio for 2018 (round answers to two decimal places). What do the outcomes tell a potential investor about Millennial Manufacturing if industry average is 2.6 times and number of days sales ratio is 180 days?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 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_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.) 1. Average collection period enter a number of days rounded to 2 decimal places days 2. Current ratio enter…arrow_forward
- Presented below are the ending balances of accounts for the Kansas Instruments Corporation at December 31, 2021. Account Title Debits Credits Cash $ 31,000 Accounts receivable 152,000 Raw materials 35,000 Notes receivable 111,000 Interest receivable 14,000 Interest payable $ 16,000 Investment in debt securities 43,000 Land 61,000 Buildings 1,520,000 Accumulated depreciation—buildings 631,000 Work in process 53,000 Finished goods 100,000 Equipment 322,000 Accumulated depreciation—equipment 141,000 Patent (net) 131,000 Prepaid rent (for the next two years) 71,000 Deferred revenue 47,000 Accounts payable 191,000 Notes payable 510,000 Restricted cash (for payment of notes payable) 91,000 Allowance for uncollectible accounts 24,000 Sales…arrow_forwardMoxley Corporation had January 1 and December 31 balances as follows. 1/1/17 12/31/17 Inventory $95,000 $113,000 Accounts payable 61,000 69,000 For 2017, cost of goods sold was $500,000. Compute Moxley’s 2017 cash payments to suppliers.arrow_forwardUsing the information provided, what is the length of the production cycle for the firm? Allied Industries, Inc. Selected Income Statement Items, 2017 Cash Sales $1,500,000 Credit Sales $7,500,000 Total Sales $9,000,000 COGS $6,000,000 Allied Industries, Inc. Selected Balance Sheet Accounts 12/31/201712/31/2016Change Accounts Receivable $270,000 $240,000 $30,000 Inventory $125,000 $100,000 $25,000 Accounts Payable $110,000 $90,000 $20,000arrow_forward
- Presented below are the ending balances of accounts for the Kansas Instruments Corporation at December 31, 2024. Account Title Debits Credits Cash $ 38,000 Accounts receivable 166,000 Raw materials 42,000 Notes receivable 118,000 Interest receivable 21,000 Interest payable $ 23,000 Investment in debt securities 50,000 Land 68,000 Buildings 1,660,000 Accumulated depreciation—buildings 638,000 Work in process 60,000 Finished goods 107,000 Equipment 336,000 Accumulated depreciation—equipment 148,000 Patent (net) 138,000 Prepaid rent (for the next two years) 78,000 Deferred revenue 54,000 Accounts payable 198,000 Notes payable 580,000 Restricted cash (for payment of notes payable) 98,000 Allowance for uncollectible accounts 31,000 Sales revenue 1,160,000 Cost of goods sold 468,000 Rent expense 46,000 Additional Information: The notes receivable, along with any interest receivable, are…arrow_forwardIvanhoe Automotive’s balance sheet at the end of its most recent fiscal year shows the following information: Ivanhoe AutomotiveBalance Sheet as of March 31, 2017 Assets: Liabilities and Equity: Cash and marketable sec. $40,000 Accounts payable and accruals $168,000 Accounts receivable 158,000 Notes payable 27,000 Inventory 232,000 Total current assets $430,000 Total current liabilities $195,000 Long-term debt 172,000 Total liabilities $367,000 Net plant and equipment 780,000 Common stock 317,000 Goodwill and other assets 92,000 Retained earnings 618,000 Total assets $1,302,000 Total liabilities and equity $1,302,000 In addition, it was reported that the firm had a net income of $159,000 on net sales of $4,200,000.Excel Template(Note: This template includes the problem statement as it appears in your textbook. The problem assigned to you here may have different values. When using…arrow_forwardThe following selected accounts from the Culver Corporation’s general ledger are presented below for the year ended December 31, 2017: Advertising expense $ 61,600 Interest revenue $ 33,600 Common stock 280,000 Inventory 75,040 Cost of goods sold 1,215,200 Rent revenue 26,880 Depreciation expense 140,000 Retained earnings 599,200 Dividends 168,000 Salaries and wages expense 756,000 Freight-out 28,000 Sales discounts 9,520 Income tax expense 78,400 Sales returns and allowances 45,920 Insurance expense 16,800 Sales revenue 2,688,000 Interest expense 78,400 Prepare a multiple-step income statement. CULVER CORPORATIONIncome Statementchoose the accounting period select an opening name for section one enter an income statement item $enter…arrow_forward
- Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax CollegeManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning