MANAGERIAL ACCOUNTING W/CONNECT >IC<
MANAGERIAL ACCOUNTING W/CONNECT >IC<
5th Edition
ISBN: 9781259907760
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
The management of Zigby Manufacturing prepared the following balance sheet for March 31. ZIGBY MANUFACTURING Balance Sheet March 31 Assets     Liabilities and Equity     Cash   $ 104,000 Liabilities     Accounts receivable   895,440 Accounts payable $ 522,600   Raw materials inventory   256,100 Loan payable 12,000   Finished goods inventory   846,404 Long-term note payable 1,300,000 $ 1,834,600 Equipment $ 1,560,000   Equity     Less: Accumulated depreciation 390,000 1,170,000 Common stock 871,000         Retained earnings 566,344 1,437,344 Total assets   $ 3,271,944 Total liabilities and equity   $ 3,271,944 To prepare a master budget for April, May, and June, management gathers the following information. Sales for March total 53,300 units. Budgeted sales in units follow: April, 53,300; May, 50,700; June, 52,000; and July, 53,300. The product’s selling price is $24.00 per unit and its total product cost is $19.85 per unit. Raw materials inventory consists…
The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2019.  ZIGBY MANUFACTURINGEstimated Balance SheetMarch 31, 2019 Assets         Cash $ 80,000     Accounts receivable   364,000     Raw materials inventory   96,000     Finished goods inventory   364,800     Total current assets   904,800     Equipment   610,000     Accumulated depreciation   (155,000 )   Equipment, net   455,000     Total assets $ 1,359,800     Liabilities and Equity         Accounts payable $ 195,500     Short-term notes payable   17,000     Total current liabilities   212,500     Long-term note payable   510,000     Total liabilities   722,500     Common stock   340,000     Retained earnings   297,300     Total stockholders’ equity   637,300     Total liabilities and equity $ 1,359,800        To prepare a master budget for April, May, and June of 2019, management gathers the following information.  Sales for March total…
The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2019:  ZIGBY MANUFACTURINGEstimated Balance SheetMarch 31, 2019 Assets         Cash $ 40,000     Accounts receivable   342,248     Raw materials inventory   98,500     Finished goods inventory   325,540     Total current assets   806,288     Equipment   600,000     Accumulated depreciation   (150,000 )   Equipment, net   450,000     Total assets $ 1,256,288     Liabilities and Equity         Accounts payable $ 200,500     Short-term notes payable   12,000     Total current liabilities   212,500     Long-term note payable   500,000     Total liabilities   712,500     Common stock   335,000     Retained earnings   208,788     Total stockholders’ equity   543,788     Total liabilities and equity $ 1,256,288        To prepare a master budget for April, May, and June of 2019, management gathers the following information.  Sales for March total…

Chapter 7 Solutions

MANAGERIAL ACCOUNTING W/CONNECT >IC<

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
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
Text book image
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Text book image
Financial Accounting Intro Concepts Meth/Uses
Finance
ISBN:9781285595047
Author:Weil
Publisher:Cengage
Text book image
Entrepreneurial Finance
Finance
ISBN:9781337635653
Author:Leach
Publisher:Cengage
Text book image
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
The KEY to Understanding Financial Statements; Author: Accounting Stuff;https://www.youtube.com/watch?v=_F6a0ddbjtI;License: Standard Youtube License