PA MO 3 :x f 8 A 1 Part 2 2 Horses Company projected the following...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
PA MO 3 :x f 8 A 1 Part 2 2 Horses Company projected the following January 31 balance sheet 3 Assets 4 5 Cash 6 Accounts receivable(net of uncollectible") 10. 11 "Allowance for uncollectibles 12 Accumulated Depreciation 7 Merchandise Inventory & Plant assets (net of accumulated deprecation") 9 Total Assets 13 14 Additional information: 15 Expected sales for February 16 Expected sales for March 17 All Sales are made on account. 18 The monthly collection pattern: 19 Penda C 27 Monthly Selling and administrative expenses are 28 Seling and Administrative expenses that use cash are paid monthly Print FERRE Pwll Budget PW12 D $ % 9 $2,880 $120,000 $240,000 $260,000 18 $20,000 69,120 104,800 72,000 $265,920 20 21 Therefore, the January accounts receivable and allowance for uncollectibles reflect only accounts for January 22 Cost of Goods Sold is 64% of sales 23 Purchases each month are made to meet 60% of the current months sales 24 40% of the next months project sales 25 All purchases are paid in full in the month following purchase. 26 Dividends of Cont C Formatting S F Accounts Payable 51% Collected in month of sale 47% Collected in month after sale 2% Uncollectible G $8,000 Declared and paid February $40,000 of which H Common Stock Retained earnings Total Liabilities and Stockholders' Equity $4,000 is depreciation 1 J Sat Fr 46,000 79,520 PH& www Des $140,400 125,520 $265,920 15 Expected sales for February 16 Expected sales for March 17 All Sales are made on account. 18 The monthly collection pattern: 19 20 21 Therefore, the January accounts receivable and allowance for uncollectibles reflect only accounts for January. 22 Cost of Goods Sold is 23 Purchases each month are made to meet 24 25 All purchases are paid in full in the month following purchase. 26 Dividends of 27 Monthly Selling and administrative expenses are 28 Selling and Administrative expenses that use cash are paid monthly 29 30 Required: Use cell referencing of information above to calculate the following and make sure you label calculations, so lo 31 1. What were January budgeted sales? Part $260,000 32 2. What will be the budgeted cash collection for February? 33 3. What will the Merchandise Inventory balance for February 28? 34 4. What will be the budgeted net income for February? 35 5. What will the budgeted balance in retained earning account at February 28? 36 6. What will be the cash available at February 28? 37 38 Solution: 20 1 What ware January hudinated ealee? Projects BudgetPart Part2 > Ready Accessibility: Investigate + 51% Collected in month of sale 47% Collected in month after sale 2% Uncollectible 64% of sales 60% of the current months sales 40% of the next months project sales $8,000 Declared and paid February $40,000 of which $4,000 is depreciation PA MO 3 :x f 8 A 1 Part 2 2 Horses Company projected the following January 31 balance sheet 3 Assets 4 5 Cash 6 Accounts receivable(net of uncollectible") 10. 11 "Allowance for uncollectibles 12 Accumulated Depreciation 7 Merchandise Inventory & Plant assets (net of accumulated deprecation") 9 Total Assets 13 14 Additional information: 15 Expected sales for February 16 Expected sales for March 17 All Sales are made on account. 18 The monthly collection pattern: 19 Penda C 27 Monthly Selling and administrative expenses are 28 Seling and Administrative expenses that use cash are paid monthly Print FERRE Pwll Budget PW12 D $ % 9 $2,880 $120,000 $240,000 $260,000 18 $20,000 69,120 104,800 72,000 $265,920 20 21 Therefore, the January accounts receivable and allowance for uncollectibles reflect only accounts for January 22 Cost of Goods Sold is 64% of sales 23 Purchases each month are made to meet 60% of the current months sales 24 40% of the next months project sales 25 All purchases are paid in full in the month following purchase. 26 Dividends of Cont C Formatting S F Accounts Payable 51% Collected in month of sale 47% Collected in month after sale 2% Uncollectible G $8,000 Declared and paid February $40,000 of which H Common Stock Retained earnings Total Liabilities and Stockholders' Equity $4,000 is depreciation 1 J Sat Fr 46,000 79,520 PH& www Des $140,400 125,520 $265,920 15 Expected sales for February 16 Expected sales for March 17 All Sales are made on account. 18 The monthly collection pattern: 19 20 21 Therefore, the January accounts receivable and allowance for uncollectibles reflect only accounts for January. 22 Cost of Goods Sold is 23 Purchases each month are made to meet 24 25 All purchases are paid in full in the month following purchase. 26 Dividends of 27 Monthly Selling and administrative expenses are 28 Selling and Administrative expenses that use cash are paid monthly 29 30 Required: Use cell referencing of information above to calculate the following and make sure you label calculations, so lo 31 1. What were January budgeted sales? Part $260,000 32 2. What will be the budgeted cash collection for February? 33 3. What will the Merchandise Inventory balance for February 28? 34 4. What will be the budgeted net income for February? 35 5. What will the budgeted balance in retained earning account at February 28? 36 6. What will be the cash available at February 28? 37 38 Solution: 20 1 What ware January hudinated ealee? Projects BudgetPart Part2 > Ready Accessibility: Investigate + 51% Collected in month of sale 47% Collected in month after sale 2% Uncollectible 64% of sales 60% of the current months sales 40% of the next months project sales $8,000 Declared and paid February $40,000 of which $4,000 is depreciation
Expert Answer:
Answer rating: 100% (QA)
1 To calculate the January budgeted sales we can refer to cell D2 which shows the total liabilities and stockholders equity The value in this cell rep... View the full answer
Related Book For
A Survey of Mathematics with Applications
ISBN: 978-0134112107
10th edition
Authors: Allen R. Angel, Christine D. Abbott, Dennis Runde
Posted Date:
Students also viewed these accounting questions
-
Marine scientists who study dolphin communication have discovered that bottlenose dolphins exhibit an individualized whistle contour known as their signature whistle. A study was conducted to...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Brookes Books is a retail book store. The company is owned by Brooke Riley, the only shareholder (to be). Brooke has asked you to keep the records for the store and to prepare its financial...
-
BA%20508%202022%20Sprg%20Group%20Proj%202%20instructions.pdf ^ Total variable OH incurred during the year was $83,420 and total fixed OH incurred was $140,540. OH gets applied to products using...
-
A business issued a 45-day, 6% note for $80,000 to a creditor on account. Journalize the entries to record (a) The issuance of the note and (b) The payment of the note at maturity, including interest.
-
As company secretary of small-to- medium-enterprise trading in securities as a brokerage company. The CEO has it that reliable information is an important aspect to the company's daily operation in...
-
A batch of 200 laptops contains three defective laptops. You choose three laptops at random. What is the probability that you have (a) no defective laptops? (b) all three defective laptops? (c) two...
-
Altuve Co. was incorporated on January 1, 2013, at which time 500,000 shares of $1 par value common stock were authorized, and 210,000 of these shares were issued for $15 per share. Net income for...
-
What role does non-Fourier heat conduction play in microscale and nanoscale heat transfer, and how do theories like the Cattaneo-Vernotte model or the dual-phase-lag model address these non-classical...
-
Plot the data in Problem 1 on a column chart in which good defensive games are highlighted in green, bad games in red, and other games in orange. Data from in problem 1 The Indiana University...
-
Our firm is considering producing a new variety of widget. Youhave already test marketed the widgets at a cost of $90,000.. You estimate sales will be $500,000 in the first year, $800,000 in the...
-
You were introduced to urboun (a nonrefundable deposit) in this chapter. Use Google to find the meaning of another deposit termed hamish al jiddiyah, which is refundable. Explain the difference...
-
The following is the statement of financial position for MNC Ltd as at December 31, 2018. Notes to the account: 1. This includes raw materials of $71,000 and work-in-progress of $29,000. 2. This...
-
Choose a brand and evaluate its channel plan (where the brand engages with the target audience). What conclusions could you draw about the fit of the channel?
-
What are the primary motives that drive social media participation?
-
What is social publishing? What kinds of content can be published socially?
-
the length of a painting is 2 inches longer than the width. The area of the painting is 48in^(2). If a 3 inch frame is put around the painting what is the area of the frames?
-
Currently, there are five concepts of food stands, including: hot dogs, soft pretzels, turkey legs, sandwich wraps, and funnel cakes. This approach will double the existing number of food stands...
-
If the quadrilateral is a parallelogram, then the opposite sides are parallel. Write the contrapositive of the statement. Use the contrapositive to determine whether the conditional statement is true...
-
Determine the volume of the block shown in Fig. 6.2, excluding the hole. The formula for the volume of a rectangular solid is V = lwh. The formula for the volume of a cylinder is V = Ïr 2 h....
-
Mowing the lawn, trimming the bushes, and removing dead limbs from trees. Determine whether the activity can be used to illustrate the associative property. For the property to hold, doing the first...
-
A political pollster approaches people on the street and asks them to describe their political affiliation. Twenty-eight people describe themselves as Democrats, 25 as Republicans, 8 people provide a...
-
Listed below are a number of hypothetical research hypotheses. For each hypothesis, identify the independent and dependent variable. a. Male drivers are more likely to exhibit road rage behaviors...
-
Listed below are a number of research questions and hypotheses from actual published articles. For each hypothesis, identify the independent and dependent variable. a. The use of color in a Yellow...
Study smarter with the SolutionInn App