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

Videos

Question
Book Icon
Chapter 7, Problem 7PSA
To determine

(1)

Concept introduction:

Money (cash) forecast: Money (cash) acceptance forecast amounts to the outflow and inflow of money (cash) in the forecast period to ascertain the equilibrium of money (cash) commitment.

To prepare:

Table showing cash collected through credit sales (balance due) in June and July.

Expert Solution
Check Mark

Answer to Problem 7PSA

Particulars April $ May $ June $ July $ August $
Collection made 144000 432000 597600 820800 889200

Explanation of Solution

Table of collection through Money(cash)

Particulars April $ May $ June $ July $ August $
Sales 720000 360000 1080000 900000 684000
Collection made 720000×20%=144000 (720000×50%) +(360000×20%)=432000 720000×28%+360000×50%+1080000×20%=597600 360000×28%+1080000×50%+900000×20%=820800 1080000×28%+900000×50%+684000×20%=889200
To determine

(2)

Concept introduction:

Money (cash) forecast: Money (cash) acceptance forecast amounts to the outflow and inflow of money (cash) in the forecast period to ascertain the equilibrium of money (cash) commitment.

To prepare:

Budget inventory (ending) for April, May, June and July.

Expert Solution
Check Mark

Answer to Problem 7PSA

Particulars April $ May $ June $ July $
Closing inventory 400 1200 1000 760

Explanation of Solution

Computation of forecasted (budgeted) closing stock for April, May, June, and July.

Particulars April $ May $ June $ July $ August $
Unit 4000 2000 6000 5000 3800
Closing inventory(20*of succeeding month sales) 400 1200 1000 760 -
To determine

(3)

Concept introduction:

Money (cash) forecast: Money (cash) acceptance forecast amounts to the outflow and inflow of money (cash) in the forecast period to ascertain the equilibrium of money (cash) commitment.

To prepare:

Purchase budget for May, June and July.

Expert Solution
Check Mark

Answer to Problem 7PSA

Particulars April $ May $ June $ July $
Units to be bought 4500 2900 5900 4860

Explanation of Solution

Purchase forecast (budget):

Particulars April $ May $ June $ July $ August $
Units 4000 2000 6000 5000 3800
Less-beginning inventory - 400 1200 1000 760
Add-ending inventory 400 1200 1000 760 -
Add-stock for safety 100 100 100 100 100
Units to be bought 4500 2900 5900 4860 3140
To determine

(4)

Concept introduction:

Money (cash) forecast: Money (cash) acceptance forecast amounts to the outflow and inflow of money (cash) in the forecast period to ascertain the equilibrium of money (cash) commitment.

To prepare:

Table showing cash payment in June and July.

Expert Solution
Check Mark

Answer to Problem 7PSA

Months June$ July$
Amount 484000 594000

Explanation of Solution

Cash schedule for payment

Particulars April$ May$ June$ July$ August$
Unit 4000 2000 6000 5000 3800
Price /unit 110 110 110 110 110
Purchase 440000 220000 660000 550000 418000
Amount (440000×.60)=264000 440000×.40 +660000×.60 =308000 220000×.40 +660000×.60 =484000 660000×.40 +550000×.60 =594000 550000×.40 +418000×.60 =470800
To determine

(5)

Concept introduction:

Money (cash) forecast: Money (cash) acceptance forecast amounts to the outflow and inflow of money (cash) in the forecast period to ascertain the equilibrium of money (cash). commitment.

To prepare:

Cash budget for the month of June and July.

Expert Solution
Check Mark

Answer to Problem 7PSA

Total of cash in June and July is same i.e. 100000

Explanation of Solution

Cash budget

Particulars June July
Cash received 597600 820800
Less-cash paid 660000 550000
Less-expenses for sales 1320000
Amount for loan 1382400 1377488
Less-interest paid amount - 1658888
Cash 100000 100000
To determine

(6)

Concept introduction:

Money (cash) forecast: Money (cash) acceptance forecast amounts to the outflow and inflow of money (cash) in the forecast period to ascertain the equilibrium of money (cash) commitment.

To discuss:

Reasons that would help the firm manage cash for the month of May.

Expert Solution
Check Mark

Answer to Problem 7PSA

If it was known to the company that it required more borrowing in June, i.e., more than $18000 as per the cash budget of the company in May itself, then company would have made less investment in May so that borrowing would have not been required that much in June. Also, the company would have realised its amount receivable from the customer to whom credit sales has been made.

Explanation of Solution

If it was known to the company that it required more borrowing in June, i.e., more than $18000 as per the cash budget of the company in May itself, then the company would have made less investment in May so that the borrowing would have not been required that much in June. Also, the company would have realised its amount receivable from the customer to whom credit sales has been made.

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
CLARITY Company makes one product. Its sales price is expected to be PS2 per unit. Actual 2021 sales: November 6,200 units December 6,800 umits CLARITY budgets its sales for the next six months of 2021 as follows: Jamuary February 5,400 units April 5,000 units 5,200 units May 5,500 units June 5,800 units 6,000 units March All sales are on account. CLARITY collects its accounts as follows: 70% in the month of sale 20% in the month following sale 10% in the second month following sale Uncollectible accounts are negligible and can be disregarded. The beginning inventory on January 1, 2022 is 540 units. CLARITY desires an ending finished goods inventory of 10% of the next month's budgeted sales. Each unit of finished goods requires 4 kilos of raw material that cost P3 a kilo. CLARITY desires an ending inventory of raw materials equal to 20% of the following month's production needs. Assume that CLARITY met this requirement at the end of December, 2021. CLARITY makes all purchases on…
Corning Incorporated sells its product for $24 per unit.  Its actual and projected sales follow:     Units Dollars January (actual) 18,500 $444,000 February (actual) 23,000    552,000 March (budgeted) 19,800    475,200 April (budgeted) 18,950    454,800 May (budgeted) 22,000    528,000   Here is added information about Corning’s operations:   All sales are on credit.  Recent experience show that 35% of sales are collected in the month of the sale, 45% in the month following the sale, 17% in the second month after the sale, and 3% prove to be uncollectible.  The product’s purchase price is $15 per unit.  All payments are payable within 21 days.  Thus 30% of purchases in any given month are paid for in that month, with the remaining 70% paid for in the following month.  The company has a policy to maintain an ending inventory of 20% of the next month’s projected sales plus a safety stock of 100 units.  The January 31 and February 28…
Corning Incorporated sells its product for $24 per unit.  Its actual and projected sales follow:     Units Dollars January (actual) 18,500 $444,000 February (actual) 23,000    552,000 March (budgeted) 19,800    475,200 April (budgeted) 18,950    454,800 May (budgeted) 22,000    528,000   Here is added information about Corning’s operations:   All sales are on credit.  Recent experience show that 35% of sales are collected in the month of the sale, 45% in the month following the sale, 17% in the second month after the sale, and 3% prove to be uncollectible.  The product’s purchase price is $15 per unit.  All payments are payable within 21 days.  Thus 30% of purchases in any given month are paid for in that month, with the remaining 70% paid for in the following month.  The company has a policy to maintain an ending inventory of 20% of the next month’s projected sales plus a safety stock of 100 units.  The January 31 and February 28…

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
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
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
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Text book image
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
What is Risk Management? | Risk Management process; Author: Educationleaves;https://www.youtube.com/watch?v=IP-E75FGFkU;License: Standard youtube license