MANAGERIAL ACCOUNTING FUND. W/CONNECT
MANAGERIAL ACCOUNTING FUND. W/CONNECT
5th Edition
ISBN: 9781259688713
Author: Wild
Publisher: MCG
bartleby

Concept explainers

bartleby

Videos

Question
Book Icon
Chapter 7, Problem 4PSB
To determine

(1)

Concept introduction:

Master forecast

Master budget is a detailed plan for upcoming, it start with sales forecast and ends with money (cash) forecast and with statement of finance. It is also known as combined forecast produced by the company at a very small level. It also include budget for money (cash), budgeted statement of finance and financial plan.

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.

Expert Solution
Check Mark

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
To determine

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

Expert Solution
Check Mark

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
To determine

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

Expert Solution
Check Mark

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
To determine

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

Expert Solution
Check Mark

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
To determine

(5)

Concept introduction:

Factory overhead forecast is that forecast which consists of cost of production apart from cost relating to direct material (DM) and direct labour.

Factory overhead forecast for the third quarter of the calendar.

Expert Solution
Check Mark

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
To determine

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

Expert Solution
Check Mark

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
To determine

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

Expert Solution
Check Mark

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
(300000×0.9%)
2700 2700 2700
Expenses total $11700 $11700 $11700
To determine

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

Expert Solution
Check Mark

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
To determine

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

Forecasted income statement for the entire third quarter.

Expert Solution
Check Mark

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)
(60000×$14.35)
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
(11160×35%)
3906
Net revenue $7254

Hence it is determined that net revenue for third quarter is $7254.

To determine

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

Expert Solution
Check Mark

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?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
Selected information from the comparative financial statements of Barcelona Company for the year ended December 31 appears below: 2017 2016 Accounts receivable (net) $200,000 175,000 Inventory 170,000 130,000 Total assets 1,100,000 800,000 Current liabilities 140,000 110,000 Long-term debt 300,000 410,000 Net credit sales 900,000 700,000 Cost of goods sold 530,000 600,000 Interest expense 40,000 25,000 Income tax expense 60,000 29,000 Net income 120,000 85,000 Net cash provided by operating activities 250,000 135,000 Instructions Answer the following questions relating to the year ended December 31, 2017. Show computations. 1. The inventory turnover for 2017 is 2. The number of times interest earned in 2017 is 3. The accounts receivable turnover for 2017 is 4. The return on assets for 2017 is
Selected information about income statement accounts for the Reed Company is presented below (the company's fiscal year ends on December 31):      2018   2017 Sales $ 4,550,000 $ 3,650,000 Cost of goods sold   2,890,000   2,030,000 Administrative expenses   830,000   705,000 Selling expenses   390,000   342,000 Interest revenue   153,000   143,000 Interest expense   206,000   206,000 Loss on sale of assets of discontinued component   62,000   —    On July 1, 2018, the company adopted a plan to discontinue a division that qualifies as a component of an entity as defined by GAAP. The assets of the component were sold on September 30, 2018, for $62,000 less than their book value. Results of operations for the component (included in the above account balances) were as follows:    1/1/18-9/30/18   2017   Sales   $ 430,000       $ 530,000   Cost of goods sold     (305,000 )       (338,000 ) Administrative expenses     (53,000 )       (43,000 ) Selling…
Presented 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. Inventories are valued at lower-of-cost-or-market using LIFO. Equipment is recorded at cost. Accumulated depreciation, computed on a straight-line basis, is $50,600. The short-term investments have a fair value of $29,000. The notes receivable are due April 30, 2022,…

Chapter 7 Solutions

MANAGERIAL ACCOUNTING FUND. W/CONNECT

Ch. 7 - How does budgeting help management coordinate and...Ch. 7 - Why is the sales budget so important to the...Ch. 7 - What is the selling expense budget? What is the...Ch. 7 - Prob. 9DQCh. 7 - GOOGLE Google prepares a cash budget. What is a...Ch. 7 - Prob. 11DQCh. 7 - Prob. 12DQCh. 7 - Prob. 13DQCh. 7 - Prob. 14DQCh. 7 - Prob. 1QSCh. 7 - Prob. 2QSCh. 7 - Identify which of the following sets of items are...Ch. 7 - Prob. 4QSCh. 7 - Prob. 5QSCh. 7 - Prob. 6QSCh. 7 - Prob. 7QSCh. 7 - Prob. 8QSCh. 7 - Prob. 9QSCh. 7 - Prob. 10QSCh. 7 - Prob. 11QSCh. 7 - Prob. 12QSCh. 7 - Prob. 13QSCh. 7 - Prob. 14QSCh. 7 - Prob. 15QSCh. 7 - Manufacturing: Production budget P1 Atlantic Surf...Ch. 7 - Prob. 17QSCh. 7 - Prob. 18QSCh. 7 - Prob. 19QSCh. 7 - Cash receipts, with uncollectible accounts P2 The...Ch. 7 - Cash receipts, with uncollectible accounts P2 Well...Ch. 7 - Prob. 22QSCh. 7 - Prob. 23QSCh. 7 - Prob. 24QSCh. 7 - Prob. 25QSCh. 7 - Prob. 26QSCh. 7 - Prob. 27QSCh. 7 - Prob. 28QSCh. 7 - Prob. 29QSCh. 7 - Prob. 30QSCh. 7 - Activity-based budgeting is a budget system based...Ch. 7 - Royal Phillips Electronics of the Netherlands...Ch. 7 - Prob. 1ECh. 7 - Prob. 2ECh. 7 - Prob. 3ECh. 7 - Prob. 4ECh. 7 - Exercise 20-5 Manufacturing: Direct labor budget...Ch. 7 - Prob. 6ECh. 7 - Prob. 7ECh. 7 - Prob. 8ECh. 7 - Prob. 9ECh. 7 - Prob. 10ECh. 7 - Prob. 11ECh. 7 - Electro Company manufactures an innovative...Ch. 7 - Prob. 13ECh. 7 - Prob. 14ECh. 7 - Prob. 15ECh. 7 - Prob. 16ECh. 7 - Prob. 17ECh. 7 - Prob. 18ECh. 7 - Prob. 19ECh. 7 - Prob. 20ECh. 7 - Prob. 21ECh. 7 - Prob. 22ECh. 7 - Prob. 23ECh. 7 - Prob. 24ECh. 7 - Prob. 25ECh. 7 - Prob. 26ECh. 7 - Prob. 27ECh. 7 - Prob. 28ECh. 7 - Prob. 29ECh. 7 - Prob. 30ECh. 7 - Prob. 31ECh. 7 - Prob. 32ECh. 7 - Prob. 33ECh. 7 - Prob. 34ECh. 7 - Prob. 1PSACh. 7 - Prob. 2PSACh. 7 - Prob. 3PSACh. 7 - The management of Zigby Manufacturing prepared the...Ch. 7 - Kegglers Supply is a merchandiser of three...Ch. 7 - Prob. 6PSACh. 7 - Prob. 7PSACh. 7 - Near the end of 2015, the management of Dimondale...Ch. 7 - Prob. 1PSBCh. 7 - Prob. 2PSBCh. 7 - Prob. 3PSBCh. 7 - Prob. 4PSBCh. 7 - Prob. 5PSBCh. 7 - Prob. 6PSBCh. 7 - Prob. 7PSBCh. 7 - Near the end of 2015, the management of Isle...Ch. 7 - Prob. 7SPCh. 7 - Prob. 1BTNCh. 7 - Prob. 2BTNCh. 7 - ETHICS CHALLENGE C1 BTN 20-3 Both the budget...Ch. 7 - Prob. 4BTNCh. 7 - Prob. 5BTNCh. 7 - Prob. 6BTNCh. 7 - Prob. 7BTNCh. 7 - Prob. 8BTNCh. 7 - Access Samsungs income statement (in Appendix A)...
Knowledge Booster
Background pattern image
Accounting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
FINANCIAL ACCOUNTING
Accounting
ISBN:9781259964947
Author:Libby
Publisher:MCG
Text book image
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Text book image
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Text book image
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Text book image
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Text book image
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education
The KEY to Understanding Financial Statements; Author: Accounting Stuff;https://www.youtube.com/watch?v=_F6a0ddbjtI;License: Standard Youtube License