(1)
Concept introduction:
Money (cash)
To prepare:
Table showing cash collected through credit sales (balance due) in June and July.
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 |
(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.
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 | - |
(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.
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 |
(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.
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 |
(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:
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 |
(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.
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?
Chapter 7 Solutions
MANAGERIAL ACCOUNTING FUND. W/CONNECT
- Pilsner Inc. purchases raw materials on account for use in production. The direct materials purchases budget shows the following expected purchases on account: Pilsner typically pays 25% on account in the month of billing and 75% the next month. Required: 1. How much cash is required for payments on account in May? 2. How much cash is expected for payments on account in June?arrow_forwardLens Junction sells lenses for $45 each and is estimating sales of 15,000 units in January and 18,000 in February. Each lens consists of 2 pounds of silicon costing $2.50 per pound, 3 oz of solution costing $3 per ounce, and 30 minutes of direct labor at a labor rate of $18 per hour. Desired inventory levels are: Â Prepare a sales budget, production budget. direct materials budget for silicon and solution, and a direct labor budget.arrow_forwardLens & Shades sells sunglasses for $37 each and is estimating sales of 21,000 units in January and 19,000 in February. Each lens consist of 2.00 mm of plastic costing $2.50 per mm, 1.7 oz of dye costing $2.80 per ounce. and 0.50 hours direct labor at a labor rate of $18 per unit. Desired inventory levels are: Prepare a sales budget, production budget, direct materials budget for silicon and solution, and a direct labor budget.arrow_forward
- Drainee purchases direct materials each month. Its payment history shows that 65% is paid in the month of purchase with the remaining balance paid the month after purchase. Prepare a cash payment schedule for January using this data: in December through February, it purchased $22,000, $25,000, and $23,000 respectively.arrow_forwardDesiccate purchases direct materials each month. Its payment history shows that 70% is paid in the month of purchase with the remaining balance pad the month after purchase. Prepare a cash payment schedule for March if in January through March, it purchased $35,000, $37,000, and $39,000, respectively.arrow_forwardEastman, Inc., manufactures and sells three products: R, S, and T. In January, Eastman, Inc., budgeted sales of the following. At the end of the year, actual sales revenue for Product R and Product S was 3,075,000 and 3,254,000, respectively. The actual price charged for Product R was 25 and for Product S was 20. Only 10 was charged for Product T to encourage more consumers to buy it, and actual sales revenue equaled 540,000 for this product. Required: 1. Calculate the sales price and sales volume variances for each of the three products based on the original budget. 2. Suppose that Product T is a new product just introduced during the year. What pricing strategy is Eastman, Inc., following for this product?arrow_forward
- Sports Socks has a policy of always paying within the discount period and each of its suppliers provides a discount of 2% if paid within 10 days of purchase. Because of the purchase policy, 85% of its payments are made in the month of purchase and 15% are made the following month. The direct materials budget provides for purchases of $129,582 in November, $294,872 in December, $239,582 in January, and $234,837 in February. What is the balance in accounts payable for January 31, and February 28?arrow_forwardCorning 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…arrow_forwardCorning 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…arrow_forward
- 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…arrow_forwardCorning 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…arrow_forwardАСTIVITY ABC Company makes one (1) product. Its sales price is expected to be P80 per unit. Actual sales for November 201A are 3,100 units, and 3,400 units for December 201A. ABC budgets its sales for the next six (6) months for 201B: January February 2,700 2,600 2,750 Аpril 2,500 2,900 3,000 May March June All sales are on account. ABC 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, 201B is 270 units. ABC desires an ending inventory of 10% of the next month's budgeted sales. Each unit of finished goods requires 4 kg of raw materials that cost P3.00/kg. ABC desires an ending inventory of direct materials equal to 20% of the following month's production needs. Assume that ABC met this requirement at the end of December, 201A. ABC makes all purchases on account and pays its accounts payable as follows: 60% in…arrow_forward
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub