Blue Company's accountant Bella has prepared the below forecasted credit sales for the quarter July to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Blue Company's accountant Bella has prepared the below forecasted credit sales for the quarter July to September. 50% of credit sales will be collected in the month of sales, 40% of sales will be collected in the month following the sales, and 10% of sales are collected two months after the sales. July $80,000 August $85,000 September $90,000 Credit Sales Inventory purchases are all on credit and average 50% of forecasted credit sales of each month. 50% of inventory purchases are paid for in the month of the purchase, 30% in the following month and 20% two months after the purchase. Operating expenses are paid in the month incurred and include monthly rent $2,000, wages $10,000, and utilities $400. Required: 1. Prepare a schedule for cash collections (receipts) on accounts receivable for September. 2. What would the accounts receivable balance be on 30 September? 3. Prepare a schedule for cash disbursements (payments) on accounts payable for September. 4. Prepare a cash budget for September. Cash balance on 1st September is $60,000. 5. Blue Company is considering the purchase of a new equipment in October for a new product launch. The new equipment will cost $80,000 in cash. Blue Company was hoping to fund the purchase of the new equipment from the cash flows of the business. Does Blue Company have enough cash for the purchase? Explain and provide necessary calculations. Blue Company's accountant Bella has prepared the below forecasted credit sales for the quarter July to September. 50% of credit sales will be collected in the month of sales, 40% of sales will be collected in the month following the sales, and 10% of sales are collected two months after the sales. July $80,000 August $85,000 September $90,000 Credit Sales Inventory purchases are all on credit and average 50% of forecasted credit sales of each month. 50% of inventory purchases are paid for in the month of the purchase, 30% in the following month and 20% two months after the purchase. Operating expenses are paid in the month incurred and include monthly rent $2,000, wages $10,000, and utilities $400. Required: 1. Prepare a schedule for cash collections (receipts) on accounts receivable for September. 2. What would the accounts receivable balance be on 30 September? 3. Prepare a schedule for cash disbursements (payments) on accounts payable for September. 4. Prepare a cash budget for September. Cash balance on 1st September is $60,000. 5. Blue Company is considering the purchase of a new equipment in October for a new product launch. The new equipment will cost $80,000 in cash. Blue Company was hoping to fund the purchase of the new equipment from the cash flows of the business. Does Blue Company have enough cash for the purchase? Explain and provide necessary calculations.
Expert Answer:
Answer rating: 100% (QA)
To answer the questions and prepare the required schedules and budgets we need to calculate the cash collections receipts on accounts receivable the accounts receivable balance on 30th September cash ... View the full answer
Related Book For
Cost management a strategic approach
ISBN: 978-0073526942
5th edition
Authors: Edward J. Blocher, David E. Stout, Gary Cokins
Posted Date:
Students also viewed these accounting questions
-
Altec Manufacturing Inc. is a company that manufactures and sells a single product, which they call an Altec. For planning and control purposes they utilize a monthly master budget, which is usually...
-
Armin Production produces cookies for resale at grocery stores throughout the country. The company is currently in the process of establishing a master budget on a quarterly basis for this coming...
-
Altec Manufacturing Inc. (Altec) is a company that manufactures and sells a single product, which they call Altec. For planning and control purposes they utilize a monthly master budget, which is...
-
Two forces are acting on the 5 kg object, with only one of them shown in Fig. 1. Knowing that F = 20 N, 0 = 30 and that the object is moving at a constant acceleration of a = 12 m/s, find the second...
-
What is the primary cause of a favorable fixed cost spending variance?
-
Given the matrices in Problems 36-39, perform elementary row operations to obtain zeros above and below the 1 in the third column without changing the entries in the first or second columns....
-
How many times can you define a function?
-
The Tall Oaks Wood Products Company is considering purchasing timberland for $5 million that would provide a future source of timber supply for the companys operations over the next 10 years....
-
returns the number of rows that contain the integer parameter. For example, if the array (as created by the Write a method called findRows that takes a two-dimension array of integers and an int as...
-
Express Co. purchased equipment on March 1, 2015, for $95,000 on account. The equipment had an estimated useful life of five years, with a residual value of $5,000. The equipment is disposed of on...
-
Taylor s deals only with five customers. The average amounts these customers pay per month are $ 1 7 , 4 0 0 , $ 1 5 , 9 0 0 , $ 2 2 , 5 0 0 , $ 5 7 , 8 0 0 , and $ 6 4 , 3 0 0 . The smaller two...
-
Ashfaq is tired of having stuff stolen from his garage. He sets up security cameras on the front corners of his house to catch the perpetrators in case they steal stuff again. One day, John and Peter...
-
A firm is expected to have an ROCE of 6% per year indefinitely. Its current BPS is $9.27 and it has a required return of 8.2%. The firm has a full dividend payout policy. What is the intrinsic P/B...
-
A 390 kg piano slides 3.1 m down a 23 incline and is kept from accelerating by a man who is pushing back on it parallel to the incline (see the figure(Figure 1)). Ignore friction. Figure > 1 of 1
-
What is the impact of budgeting on employee motivation and performance? Additionally, how do factors such as participative budgeting approaches, performance-based incentives, and recognition...
-
How do advanced budgeting methodologies, such as zero-based budgeting, activity-based budgeting, and beyond budgeting, provide organizations with adaptive frameworks for resource allocation, cost...
-
What is the y"-4 y' + (25/4) y = 10cos(8x) O 2C1x+ C2x-C3x OCe2x + C2e1.5x O Ce2x cos(1.5x) + C2e2x sin(1.5x) O C1ex tan(x) + Ce* cot(x) complementary solution to the following differential equation?
-
In a large midwestern university, 30% of the students live in apartments. If 200 students are randomly selected, find the probability that the number of them living in apartments will be between 55...
-
As part of the process of preparing the master budget for the coming year, you've been asked to perform what-if analyses, in the form of scenarios, on the original planning assumptions regarding...
-
Name the 13 contemporary management techniques and describe each briefly.
-
The Pentagon is constantly seeking ways to procure the most effective combat equipment and systems at the lowest possible cost. A key element in most procurement contracts is fixed fee based on...
-
Let \(Y\) be distributed according to the \(\operatorname{gamma}(265)\) distribution. (a) Find \(\mathrm{E}[Y]\). (b) Find \(\operatorname{Var}[Y]\). (c) Find \(P(Y>5)\)
-
In order to determine how e ective a magazine is at reaching its target audience, a market research company selects a random sample of people from the target audience and interviews them. Out of the...
-
Let \(Y\) be distributed according to the gamma(12 4) distribution. (a) Find \(\mathrm{E}[Y]\). (b) Find \(\operatorname{Var}[Y]\). (c) Find \(P(Y\)
Study smarter with the SolutionInn App