Office World Inc. has "cash and carry" customers and credit customers. Office World estimates that 25% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 25% pay their accounts in the month of sale, while the remaining 75% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $110,000 November 138,000 December 201,000 The Accounts Receivable balance on September 30 was $74,000. Prepare a schedule of cash collections from sales for October, November, and December. Round all calculations to the nearest whole dollar. Office World Inc. Schedule of Collections from Sales For the Three Months Ending December 31 October November December Recelpts from cash sales: Cash sales 27,500 34,500 50,250 September sales on account: Collected in October 74,000 October sales on account: Collected in October Collected in Noember November sales on account: Collected in Novermber Collected in December December sales on account: Collocted in December Tatal cash receipts

Office World Inc. has "cash and carry" customers and credit customers. Office World estimates that 25% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 25% pay their accounts in the month of sale, while the remaining 75% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $110,000 November 138,000 December 201,000 The Accounts Receivable balance on September 30 was $74,000. Prepare a schedule of cash collections from sales for October, November, and December. Round all calculations to the nearest whole dollar. Office World Inc. Schedule of Collections from Sales For the Three Months Ending December 31 October November December Recelpts from cash sales: Cash sales 27,500 34,500 50,250 September sales on account: Collected in October 74,000 October sales on account: Collected in October Collected in Noember November sales on account: Collected in Novermber Collected in December December sales on account: Collocted in December Tatal cash receipts

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter7: Budgeting

Section: Chapter Questions

Problem 14EA: Halifax Shoes has 30% of its sales in cash and the remainder on credit. Of the credit sales, 65% is...

See similar textbooks

Related questions

Q: Do

A: Taylor's Scientific Management is criticised on the following main grounds :- 1. Exploitation of…

Q: can you do it again? half of them are wr

A: Units of activity method:- The asset under this method is depreciated on the basis of total hours…

Q: what was the puzzle? what is a possible solution to solve that puzzle?

A: Puzzle- A puzzle is a game, problem, or toy that tests a personality's ingenuity or information.…

Q: Hello, I would need guidance with A-F, if possible.

A: Manufacturing overhead: It is the indirect cost incurred as a part of manufacturing the products.…

Q: I need to see the work on this for it to make sense to me, can you show your work please? (The…

A: Monthly Payment = $900 Interest rate = 6% Loan term = 30 years Compounding time = 12 (12 times in a…

Q: Assume that a perpetual inventory system is used and the records indicate that$191,400 of…

A: Hey, since there are multiple questions posted, we will answer first question. If you want any…

Q: The controller of Ferrence Company estimates the amount of materials handling overhead cost that…

A: Hey, Since there are multiple questions posted, we will answer first question. If you want any…

Q: Working out is not right, can you try again

A: Given,Face value (nominal value) = £100Issue price = £115Coupon rate = 6.6% p.a.Redemption value =…

Q: Explain how to get the answer to this problem.

A: Equivalent units: When in the product is going to the more than one process then the lots of units…

Q: Mel Snow is the manager of a firm, Taxation Matters, which specialises in the preparation of income…

A: ABC (Activity based costing) framework was created to manage the drawbacks of customary costing…

Q: Company W acquired a wastewater treatment plant for 30,000, depreciable over 10 years. The company…

A: Government grant means the amount received from government free of cost. It is received by specified…

Q: help me with the last

A: In market leader in the product States something regarding the competitions and make a different…

Q: Hello, could i depend on this solution is it an expert solution?

A: Variance - It is the difference between budgeted and actual data.There are many types of variances…

Q: Alice bought $P worth of shares in a start-up company. She created the following scenarios with the…

A: Share investments represents buying a portion of equity in a company. We buy shares of a company…

Q: On 31st of July 2023, Dino Plc which has a financial year end at 31st of March bought a bespoke…

A: Expenses means the amount spent for running the business. Fixed assets means the amount spent on…

Q: Part 1 is incorrect. Could you try the problem ag

A: Profitability index is a financial tool which tells us whether an investment should be accepted or…

Q: Hi, my name is Jennifer. I am having trouble with this same problem. But the sub-parts I need help…

A: Please find the answer to (C) in the previous answer. I am going to answer only (D) & (E) in…

Q: I need help

A: Variance in $ = Revenue in Feb'13 - Revenue in Feb'12 Variance in % = (Variance in $) / Revenue in…

Q: Company X PLC has the following general borrowings outstanding throughout the year to 30th June 2019…

A: The interest expense that is paid on a loan taken for constructing a long-term asset is generally…

Q: Could you please show me how to solve this with formulas

A: We can determine the amount to be repaid under simple interest (SI) and compound interest (CI) using…

Q: Please help! I have no clue on how to fill this table out!

A: Closing entry can be done in 2 different ways. First method is closing revenue and expense account…

Question

100%

I started this question, but I got stuck. Can someone help me?

Office World Inc. has "cash and carry" customers and credit customers. Office World estimates that 25% of monthly sales are to cash customers, while the remaining
sales are to credit customers. Of the credit customers, 25% pay their accounts in the month of sale, while the remaining 75% pay their accounts in the month following
the month of sale. Projected sales for the next three months are as follows:
October
$110,000
November
138,000
December
201,000
The Accounts Receivable balance on September 30 was $74,000.
Prepare a schedule of cash collections from sales for October, November, and December. Round all calculations to the nearest whole dollar.
Office World Inc.
Schedule of Collections from Sales
For the Three Months Ending December 31
October
November
December
Recelpts from cash sales:
Cash sales
27,500
34,500
50,250
September sales on account:
Collected in October
74,000
October sales on account:
Collected in October
Collected in Noember
November sales on account:
Collected in Novermber
Collected in December
December sales on account:
Collocted in December
Tatal cash receipts

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Working:

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

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

Earthies Shoes has 55% of its sales in cash and the remainder on credit. Of the credit sales, 70% is collected in the month of sale, 15% is collected the month after the sale, and 10% is collected the second month after the sale. How much cash will be collected in June if sales are estimated as $75,000 in April, $65,000 in May, and $90,000 in June?
Cash collections for Renew Lights found that 65% of sales were collected in the month of sale, 25% was collected the month after the sale, and 10% was collected the second month after the sale. Given the sales shown, how much cash will be collected in March and April?
Fitbands estimated sales are: What are the balances in accounts receivable for January, February, and March if 65% of sales is collected in the month of sale, 25% is collected the month after the sale, and 10% is second month after the sale?
My Aunts Closet Store collects 60% of its accounts receivable in the month of sale and 35% in the month after the sale. Given the following sales, how much cash will be collected in March?
Amusement tickets estimated sales are: What are the balances in accounts receivable for April, May, and June if 60% of sales are collected in the month of sale, 30% are collected the month after the sale, and 10% are collected the second month after the sale?
Nonnas Re-Appliance Store collects 55% of its accounts receivable in the month of sale and 40% in the month after the sale. Given the following sales, how much cash will be collected in February?
Ranger Industries has provided the following information at June 30: Other information: Average selling price, 196 Average purchase price per unit, 110 Desired ending inventory, 40% of next months unit sales Collections from customers: In month of sale20% In month after sale50% Two months after sale30% Projected cash payments: Inventory purchases are paid for in the month following acquisition. Variable cash expenses, other than inventory, are equal to 25% of each months sales and are paid in the month of sale. Fixed cash expenses are 40,000 per month and are paid in the month incurred. Depreciation on equipment is 2,000 per month. REQUIREMENT You have been asked to prepare a master budget for the upcoming quarter (July, August, and September). The components of this budget are a monthly sales budget, a monthly purchases budget, a monthly cash budget, a forecasted income statement for the quarter, and a forecasted September 30 balance sheet. The worksheet MASTER has been provided to assist you. Ranger Industries desires to maintain a minimum cash balance of 8,000 at the end of each month. If this goal cannot be met, the company borrows the exact amount needed to reach its goal. If the company has a cash balance greater than 8,000 and also has loans payable outstanding, the amount in excess of 8,000 is paid to the bank. Annual interest of 18% is paid on a monthly basis on the outstanding balance.
Negus Enterprises has an inventory conversion period of 50 days, an average collection period of 35 days, and a payables deferral period of 25 days. Assume that cost of goods sold is 80% of sales. What is the length of the firm’s cash conversion cycle? If annual sales are $4,380,000 and all sales are on credit, what is the firm’s investment in accounts receivable? How many times per year does Negus Enterprises turn over its inventory?
Medwig Corporation has a DSO of 17 days. The company averages 3,500 in sales each day (all customers take credit). What is the companys average accounts receivable?
Cash collections for Wax On Candles found that 60% of sales were collected in the month of the sale, 30% was collected the month after the sale, and 10% was collected the second month after the sale. Given the sales shown, how much cash will be collected in January and February?
Gear Up Co. pays 65% of its purchases in the month of purchase, 30% in the month after the purchase, and 5% in the second month following the purchase. What are the cash payments if it made the following purchases in 2018?
All Temps 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, 80% of its payments are made in the month of purchase and 20% are made the following month. The direct materials budget provides for purchases of $23,812 in February, $23,127 in March, $21,836 in April, and $28,173 in May.What is the balance in accounts payable for April 30, and May 31?