CONNECT ONLINE ACCESS F/MANAGERIAL ACC.
6th Edition
ISBN: 9781264445356
Author: Noreen
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Question
Chapter 8, Problem 8.1AE
1.
To determine
Introduction: Disbursements refer to the payment of money from the dedicated fund. The payments for the purchase of any kind of raw material in any previous accounting period and current budget period are the disbursements for raw material.
The reason why the total cash disbursements for raw materials increased when the budgeted unit sales changed to 75000 units and the total expected cash collections for the year becomes $2,085,000, required production becomes 274000 units, the cost of raw materials to be purchased is now $1,106,800, and the total cash disbursements for the year will be $1,095,980.
2.
To determine
Introduction: Purchase of raw materials considers all goods or equipment necessary to produce final goods and services.
(a) The total expected cash collections for the year under the revised budget, (b) the total required production for the year, (c) the total cost of raw materials to be purchased for the year, (d) the total expected cash payments for raw materials for the year, and (e) if there is a potential problem when the production manager cautioned that the plant cannot produce more than 90,000 units due to limited availability of milling machine then what needs to be done in this situation.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
owa Imaging Center provided the financial information in Exhibit 5.15 below. Prepare a cash budget for the quarter ending March 20X1. For Blackboard you will enter your ENDING cash balance for the months of January 20X1, February 20X1, March 20X1, and the Quarter ending March 20X1. I want you to submit your work for this problem by email so I can review the entire document.
Exhibit 5-15 Iowa Imaging Center
Givens
Revenues and Expenses
Patient Revenues, 20X0
Estimated Patient Revenues, 20X1
Given 1
October
$4,000,000
Given 2
January
$4,300,000
November
$4,200,000
February
$4,350,000
December
$4,300,000
March
$4,400,000
Other Revenues, 20X1
Estimated Cash Outflows, 20X1a
Given 3
January
$90,000
Given 4
January
$4,250,000…
You have been hired by the company LA PLANEACIÓN, S.A., for your track record in Cash Management and for being a CETYS student. With the following information, prepare a Cash Budget by the input-output method:
(IMAGE) ( I think it is easy to understand, especially for a bartleby expert.)
The budgeted monthly sales for the following fiscal year are:
January - 500000February - 600000March - 725000April - 650000May - 700000June - 600000July - 500000August - 550000
Sales are made: 35% cash and 65% on credit which are collected in the following month. The outstanding receivables from 2020 are on the balance sheet.
The amount of bad debts is insignificant.
Purchases are made two months in advance of what is to be sold. The purchase conditions with suppliers are: 40% of purchases are paid in cash, 30% in the month following the purchase and 30% after two months. The balance payable on the account at December 31 consists of credit purchases in November and credit purchases in December.
Cost…
Pelican Merchandising & More is a family-owned store. The business is now approaching theend of the year and is in the process of identifying its cash needs for the first quarter of the newyear. You are the management accountant of the entity and have been tasked to prepare the cashbudget for the business for the quarter ending March 31, 2022.
Extracts from the sales and purchases budgets are as follows:
An analysis of the records shows that trade receivables (accounts receivable) are settledaccording to the following credit pattern, in accordance with the credit terms 4/30, n90:55% in the month of sale35% in the first month following the sale8% in the second month following the saleThe remaining 2% is expected to be uncollectible
Accounts payable are settled as follows, in accordance with the credit terms 2/30, n60:85% in the month in which the inventory is purchased15% in the following month
The management of Pelican Merchandising has negotiated with a tenant to sublet…
Chapter 8 Solutions
CONNECT ONLINE ACCESS F/MANAGERIAL ACC.
Ch. 8 - Prob. 8.1QCh. 8 - Prob. 8.2QCh. 8 - Prob. 8.3QCh. 8 - Prob. 8.4QCh. 8 - Prob. 8.5QCh. 8 - Prob. 8.6QCh. 8 - Prob. 8.7QCh. 8 - Prob. 8.8QCh. 8 - Prob. 8.9QCh. 8 - Prob. 8.10Q
Ch. 8 - Prob. 8.1AECh. 8 - Morganton Company makes one product, and it...Ch. 8 - Prob. 8.1ECh. 8 - Prob. 8.2ECh. 8 - Prob. 8.3ECh. 8 - Prob. 8.4ECh. 8 - Prob. 8.5ECh. 8 - Prob. 8.6ECh. 8 - Prob. 8.7ECh. 8 - Prob. 8.8ECh. 8 - Prob. 8.9ECh. 8 - Prob. 8.10ECh. 8 - Prob. 8.11ECh. 8 - Prob. 8.12ECh. 8 - Prob. 8.13ECh. 8 - Prob. 8.14ECh. 8 - Prob. 8.15ECh. 8 - Prob. 8.16ECh. 8 - Prob. 8.17ECh. 8 - Prob. 8.18ECh. 8 - Prob. 8.19PCh. 8 - Prob. 8.20PCh. 8 - Prob. 8.21PCh. 8 - Prob. 8.22PCh. 8 - Prob. 8.23PCh. 8 - Prob. 8.24PCh. 8 - Prob. 8.25PCh. 8 - Prob. 8.26PCh. 8 - Prob. 8.27PCh. 8 - Prob. 8.28PCh. 8 - Prob. 8.29PCh. 8 - Prob. 8.30PCh. 8 - Prob. 8.31PCh. 8 - Prob. 8.32CCh. 8 - Prob. 8.33C
Knowledge Booster
Similar questions
- Pelican Merchandising & More is a family-owned store. The business is now approaching theend of the year and is in the process of identifying its cash needs for the first quarter of the newyear. You are the management accountant of the entity and have been tasked to prepare the cashbudget for the business for the quarter ending March 31, 2022. Extracts from the sales and purchases budgets are as follows: An analysis of the records shows that trade receivables (accounts receivable) are settledaccording to the following credit pattern, in accordance with the credit terms 4/30, n90:55% in the month of sale35% in the first month following the sale8% in the second month following the saleThe remaining 2% is expected to be uncollectible Accounts payable are settled as follows, in accordance with the credit terms 2/30, n60:85% in the month in which the inventory is purchased15% in the following month The management of Pelican Merchandising has negotiated with a tenant to sublet…arrow_forwardPelican Merchandising & More is a family-owned store. The business is now approaching theend of the year and is in the process of identifying its cash needs for the first quarter of the newyear. You are the management accountant of the entity and have been tasked to prepare the cashbudget for the business for the quarter ending March 31, 2022. Extracts from the sales and purchases budgets are as follows: An analysis of the records shows that trade receivables (accounts receivable) are settledaccording to the following credit pattern, in accordance with the credit terms 4/30, n90:55% in the month of sale35% in the first month following the sale8% in the second month following the saleThe remaining 2% is expected to be uncollectible Accounts payable are settled as follows, in accordance with the credit terms 2/30, n60:85% in the month in which the inventory is purchased15% in the following month The management of Pelican Merchandising has negotiated with a tenant to sublet…arrow_forwardPelican Merchandising & More is a family-owned store. The business is now approaching theend of the year and is in the process of identifying its cash needs for the first quarter of the newyear. You are the management accountant of the entity and have been tasked to prepare the cashbudget for the business for the quarter ending March 31, 2022. Extracts from the sales and purchases budgets are as follows: An analysis of the records shows that trade receivables (accounts receivable) are settledaccording to the following credit pattern, in accordance with the credit terms 4/30, n90:55% in the month of sale35% in the first month following the sale8% in the second month following the saleThe remaining 2% is expected to be uncollectible Accounts payable are settled as follows, in accordance with the credit terms 2/30, n60:85% in the month in which the inventory is purchased15% in the following month The management of Pelican Merchandising has negotiated with a tenant to sublet…arrow_forward
- Pelican Merchandising & More is a family-owned store. The business is now approaching theend of the year and is in the process of identifying its cash needs for the first quarter of the newyear. You are the management accountant of the entity and have been tasked to prepare the cashbudget for the business for the quarter ending March 31, 2022. Extracts from the sales and purchases budgets are as follows: An analysis of the records shows that trade receivables (accounts receivable) are settledaccording to the following credit pattern, in accordance with the credit terms 4/30, n90:55% in the month of sale35% in the first month following the sale8% in the second month following the saleThe remaining 2% is expected to be uncollectible Accounts payable are settled as follows, in accordance with the credit terms 2/30, n60:85% in the month in which the inventory is purchased15% in the following month The management of Pelican Merchandising has negotiated with a tenant to sublet…arrow_forwardPelican Merchandising & More is a family-owned store. The business is now approaching theend of the year and is in the process of identifying its cash needs for the first quarter of the newyear. You are the management accountant of the entity and have been tasked to prepare the cashbudget for the business for the quarter ending March 31, 2022. Extracts from the sales and purchases budgets are as follows: An analysis of the records shows that trade receivables (accounts receivable) are settledaccording to the following credit pattern, in accordance with the credit terms 4/30, n90:55% in the month of sale35% in the first month following the sale8% in the second month following the saleThe remaining 2% is expected to be uncollectible Accounts payable are settled as follows, in accordance with the credit terms 2/30, n60:85% in the month in which the inventory is purchased15% in the following month The management of Pelican Merchandising has negotiated with a tenant to sublet…arrow_forwardUpon receipt of the budget the team manager has now informed you that the management of Miller Merchandising & More have indicated a desire to maintain a minimum cash balance of $125,000 each month. Based on the budget prepared, will the business be achieving this desired target? Given that the management does not wish to borrow any funds from outside sources, suggest three (3) internal strategies that the business may employ in order to improve the organization’s monthly cash flow. Each strategy must be fully explained(in detailed).arrow_forward
- Upon receipt of the budget the team manager has now informed you that the management of Miller Merchandising & More have indicated a desire to maintain a minimum cash balance of $125,000 each month. Based on the budget prepared, will the business be achieving this desired target? Given that the management does not wish to borrow any funds from outside sources, suggest three (3) internal strategies that the business may employ in order to improve the organization’s monthly cash flow. Each strategy must be fully explained.arrow_forwardIn an attempt to better understand RR’s cash position, Johnson developed a cash budget for the first 2 months of the year. She has the figures for the other months, but they are not shown. After looking at the cash budget, answer the following questions: What does the cash budget show regarding the target cash level? Should depreciation expense be explicitly included in the cash budget? Why or why not? What are some other potential cash inflows besides collections? How can interest earned or paid on short-term securities or loans be incorporated in the cash budget? In her preliminary cash budget, Johnson has assumed that all sales are collected and thus that RR has no bad debts. Is this realistic? If not, how would bad debts be dealt with in a cash budgeting sense? (Hint: Bad debts will affect collections but not purchases.)arrow_forwardFriendly Bank is attempting to determine the cost behavior of its small business lending operations. One of the major activities is the application activity. Two possible activity drivers have been mentioned: application hours (number of hours to complete the application) and number of applications. The bank controller has accumulated the following data for the setup activity: Required: 1. Estimate a regression equation with application hours as the activity driver and the only independent variable. If the bank forecasts 2,600 application hours for the next month, what will be the budgeted application cost? 2. Estimate a regression equation with number of applications as the activity driver and the only independent variable. If the bank forecasts 80 applications for the next month, what will be the budgeted application cost? 3. Which of the two regression equations do you think does a better job of predicting application costs? Explain. 4. Run a multiple regression to determine the cost equation using both activity drivers. What are the budgeted application costs for 2,600 application hours and 80 applications?arrow_forward
- Varsity Supplies & Things is a family-owned store. The business is now approaching the end of the year and is desirous of identifying its expected cash inflows and outflows for the first quarter of the new year. You are the management accountant of the entity and have been tasked to prepare the cash budget for the business for the quarter ending March 31, 2023. The following data is available: Extracts from the sales and purchases budgets are as follows: Month 2022 - 2023 Cash Sales Sales On Account Cash Purchases Purchases On Account November 2022 $142,100 $480,00 $345,000 December 2022 $165,500 $600,000 $25,800 $380,000 January 2023 $171,475 $650,000 $44,625 $400,000 February 2023 $144,940 $700,000 $30,400 $480,000 March 2023 $236,720 $800,000 $55,100 $540,000 (ii) An analysis of the records shows that trade receivables (accounts receivable) are settled according to the following credit pattern, in accordance with the credit terms 4/30, n90: 55% in…arrow_forwardVarsity Supplies & Things is a family-owned store. The business is now approaching the end of the year and is desirous of identifying its expected cash inflows and outflows for the first quarter of the new year. You are the management accountant of the entity and have been tasked to prepare the cash budget for the business for the quarter ending March 31, 2023. The following data is available: Extracts from the sales and purchases budgets are as follows: Month 2022 - 2023 Cash Sales Sales on Account Cash Purchases Purchases On Account Nov-22 $142,100 $480,000 $345,000 Dec-22 $165,500 $600,000 $25,800 $380,000 Jan-23 $171,475 $650,000 $44,625 $400,000 Feb-23 $144,940 $700,000 $30,400 $480,000 Mar-23 $236,720 $800,000 $55,100 $540,000…arrow_forwardVarsity Supplies & Things is a family-owned store. The business is now approaching the end of the year and is desirous of identifying its expected cash inflows and outflows for the first quarter of the new year. You are the management accountant of the entity and have been tasked to prepare the cash budget for the business for the quarter ending March 31, 2023. The following data is available: Extracts from the sales and purchases budgets are as follows: Month 2022 - 2023 Cash Sales Sales on Account Cash Purchases Purchases On Account Nov-22 $142,100 $480,000 $345,000 Dec-22 $165,500 $600,000 $25,800 $380,000 Jan-23 $171,475 $650,000 $44,625 $400,000 Feb-23 $144,940 $700,000 $30,400 $480,000 Mar-23 $236,720 $800,000 $55,100 $540,000…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning