StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...
Free

Analysis of Cash and Credit Sales, Debt Collection, Cash Collected from Credit Sales - Assignment Example

Cite this document
Summary
The paper “Analysis of Cash and Credit Sales, Debt Collection, Cash Collected from Credit Sales” is a convincing example of a finance & accounting assignment. The paper presents schedules for monthly cash receipts and cash disbursements for the life of this venture. Show all workings and supporting schedules…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER97.5% of users find it useful

Extract of sample "Analysis of Cash and Credit Sales, Debt Collection, Cash Collected from Credit Sales"

QUESTION 1 Required a. Prepare schedules for monthly cash receipts and cash disbursements for the life of this Venture. Show all workings and supporting schedules. Cash sales = 10% of total sales Credit sales = 90% of total sales ANALYSIS OF CASH & CREDIT SALES September October November December January Unit Sales 12,000.00 22,000.00 32,000.00 40,000.00 - Cash Sales (10% × 12, 000× 50) (10% × 22, 000× 50) (10% × 32, 000× 50) (10% × 40, 000× 50)   60,000.00 110,000.00 160,000.00 200,000.00   Credit Sales (90% × 12, 000× 55) (90% × 22, 000× 55) (90% × 32, 000× 55) (90% × 40, 000× 55)   594,000.00 1,089,000.00 1,584,000.00 1,980,000.00   Total Sales 654,000.00 1,199,000.00 1,744,000.00 2,180,000.00   INFORMATION ON DEBT COLLECTION Discount Amount collected 30% of credit sales Cash within 10days: Discount of 4% 4% 96%     20% of credit sales Cash after 10 days: Discount of 2% 2% 98% 25% of credit sales cash one month following the sale 20% of credit sales Cash Two months following the sale CASH COLLECTED FROM CREDIT SALES September October November December January (96%×594,000) (96%×1,089,000) (96%×1,584,000) (96%×1,980,000)   30% of credit sales 171,072.00 313,632.00 456,192.00 570,240.00   (98%×594,000) (98%×1,089,000) (98%×1,584,000) (98%×1,980,000)   20% of credit sales 116,424.00 213,444.00 310,464.00 388,080.00     (25%×594,000) (25%×1,089,000) (25%×1,584,000)   25% of credit sales - 148,500.00 272,250.00 396,000.00       (20%×594,000) (20%×1,089,000)   20% of credit sales - - 118,800.00 217,800.00   Total from Credit 287,496.00 675,576.00 1,157,706.00 1,572,120.00   September October November December January (60,000+287,496) (110,000+675,576) (160,000+1,157,706) (200,000+1,572,120)   Cash Receipts 347,496.00 785,576.00 1,317,706.00 1,772,120.00   INFORMATION ON PAYMENTS MADE August Purchases paid in September and the september ones paid in October Discount Amount Paid 50% paid in the month of purchase : Discount of 4%   6% 94.00% 50% Paid the following month         ANALYSIS OF PURCHASES MADE September October November December January Total Sales 654,000.00 1,199,000.00 1,744,000.00 2,180,000.00   Add: Closing Balance 839,300.00 1,220,800.00 1,526,000.00 -   Less: Opening Balance 150,000.00 839,300.00 1,220,800.00 1,526,000.00   Purchases 1,343,300.00 1,580,500.00 2,049,200.00 654,000.00   Note: Closing balance is 70% 0f next months sales CASH PAYMENTS September October November December January Mail costs $2 $2 $2 $2   August & Sept Purchases 150,000.00 1,343,300.00 - -   4% Discount for 50% of monthly purchase   (50%×94%×1,580,500) (50%×94%×2,049,200) (50%×94%×654,000)   - 742,835.00 963,124.00 307,380.00   50% paid the following month     (50%×1,580,500) (50%×2,049,200)   - - 790,250.00 1,024,600.00   Total Cash Payments 150,002.00 2,086,137.00 1,753,376.00 1,331,982.00   b. Will had planned to simply write off uncollectables. However, his accounting professor suggested he turn them over to a collection agency. How much could Will let the collection agency keep (in dollars) so that so would be no worse off? Uncollectable passed on to a collectiong agency September October November December January (5%× 594,000) (5%×1,089,000) (5%×1,584,000) (5%×1,980,000)   5% of credit sales 29,700.00 54,450.00 79,200.00 99,000.00   QUESTION 2 Required: a) What is Briskay Aviation’s current monthly operating result? Occupancy rate 60%   Seats Available 250   Flights Per month 60   Ticket Price $120       (60%×250×60×$120) Total Revenue per month   $1,080,000 FIXED COSTS Flight Costs     Fuel $3,200   Crew $2,250   Others $7,900   Fixed Costs per flight $13,350 ($13,350×60) Total Fixed Costs   $801,000 VARIABLE COSTS Snack & Drink per passenger $10   Booking costs & Govt levies per passenger $6   Variable cost per passenger $16       (60%×250×60×$16) Total Variable costs   $144,000 Contribution ( Sales Less Variable Costs $936,000 b) What is the company’s current break-even point in passengers per flight, and occupancy %? Break Even = F (SP – VC) = 801,000 ÷ 104 = 7,701.92 ($7,701.92 ÷ 60) Break even per flight 128.37 Break even in occupancy (60% × 128.37) = 77.02 c) Next month (November), assuming food and drink costs do increase:  what ticket price would need to be charged to maintain the current contribution margin ratio? If food and drinks rise at 30% , the variable cost will change as below Snack & Drink per passenger $13 Booking costs & Govt levies per passenger $6 Variable cost per passenger $19 Contribution = Selling price - Variable cost 104 = x-19 Therefore, the selling price would be ($104+19) Ticket price = $123  if ticket prices are not increased, how many passengers would need to be achieved to maintain the company’s current after-tax operating result ? What occupancy rate would this represent? Contribution = Selling price - Variable cost Total Revenue per month $1,080,000 Total Variable costs $144,000 Contribution = $936,000 After tax operating results (1-0.25) × $936,000 $702,000 702000= ×-144000 x= ($702,000+144,000) Total Revenue= $846,000 Passengers ($846,000÷120) = 7,050 If 60% occupancy rate = (60%×250×60) = 9,000 passengers So?% = 7,050 (60%×9,000)÷7050 = 76.6% occupancy rate d) In addition to the increase in costs of food and drink, if aviation fuel prices increase by 20% in December, how many passengers would then be needed to maintain the company’s current after-tax operating result, without increasing ticket prices? What occupancy rate would this represent? Occupancy rate 60%   Seats Available 250   Flights Per month 60   Ticket Price $120       (60%×250×60×$120) Total Revenue per month   $1,080,000 FIXED COSTS Flight Costs     Fuel $3,200   Crew $2,250   Others $7,900   Fixed Costs per flight $13,350 ($13,350×60) Total Fixed Costs   $801,000 VARIABLE COSTS Snack & Drink per passenger $10   Booking costs & Govt levies per passenger $6   Variable cost per passenger $16       (60%×250×60×$16) Total Variable costs   $144,000 Contribution ( Sales Less Variable Costs $104 $936,000 Profit $135,000 Total Fixed Costs (801000+ 20% ×3200×60)= 839,400 Total Variable costs (60%×250×60×$19) $171,000 Profit = sales - fixed costs-variable costs 135000 (x-839400-171,000) x = (135,000+839,400+171,000) $1,145,400 Total Passengers = (1,145,450÷120) = $9,545 If 60% occupancy rate = (60%×250×60) = 9,000 passengers So?% = 9,545 (60%×9,000)÷9,545 = 56.6% occupancy rate QUESTION 3. (a). Cost of each product in the sample using the firm’s current (2014) allocation base. All production overheads are allocated on the basis of units produced. Therefore; Allocation rate = total overhead cost ÷ number of units produced Allocation rate = $ 16500000 ÷ 2500000 = $ 0.66 per unit J-275 R-895 T-28A Y-477 Units 200,000 1,000 14,000 90,000 Material cost ($) 235,000 590 2,800 50,000 Labour cost ($) 65,000 80 1,100 10,000 Overheads allocation ( 0.66) 132,000 660 9,240 59,400 Total costs of products($) 432,000 1330 13,140 119,400 (b) Two allocation bases; First allocation base is based on the units produced. This means the number of units produced is the cost driver. Therefore; Allocation rate = 350,000 ÷ 2,500,000 = $ 0.14 per unit of each product The second allocation rate is based on the number of expeditors. Therefore; Allocation rate = 1,300,000 ÷ 25 = $ 52,000 per expeditor. If 25 expeditors = 2,500,000 units 1 expeditor = 100,000 units Therefore the expeditors cost is allocated to the four products based on the number of expeditors in the production of each product in the sample. The costs of each product; Costs of each product J-275 R-895 T-28A Y-477 Units 200,000 1,000 14,000 90,000 Material cost 235,000 590 2,800 50,000 Labour cost 65,000 80 1,100 10,000 General overheads (0.14 per unit) 28,000 140 1,960 12,600 Expediting cost ( 52,000 per expd) 104,000 520 7,280 46,800 Cost of each product 632,000 2,330 27,140 209,400 (c). Product lines involves a number of different products that are produced or manufactured at the same time. Product lines incur common costs but there are other cost that are directly attributed to each product respectively. These costs are costs relating to direct materials, direct labour and direct expenses. The cost of each product is different using the two different cost allocation approaches; the current method of cost allocation where overheads are allocated using a single allocation rate and the new method where two allocation rates are used. QUESTION 4 PART A a. Why Murphy will be reluctant to build the new plant. ROI is given by Divisional margin divided by divisional investment. ROI = 1,380,000 ÷ 7,500,000 × 100 = 18.4% Comparing the rate of investment for the new plant and the current rate of investment, the ROI of the new plant 18.4% is lower hence Murphy will be reluctant to build the plant. b. The residual income is given by; Profit before tax – ( required rate of returns × investment ) RI = 1,380,000 – ( 15% × 7,500,000 ) = $ 255,000 Murphy may will to build the new plant because his decision is based on the dollar returns earned from the investment. From the investment in the new plant, the WD will realize a residual income of $ 255,000. PART B 1. For the first proposal, if Murphy’s compensation is made fixed then this will demotivate Murphy and make him reluctant to make any investments. Unless the fixed compensation is reasonable, then Murphy will decline any investment proposals made. For the second proposal, Murphy may be induced into accepting proposal on investment. These compensation arrangements will encourage Murphy to concentrate on maximizing absolute amounts rather than percentages. This arrangement will also induce Murphy into investing since he is assured of his compensation basing it on the amount of returns by comparing the amount charged on capital invested and the residual income. However, this proposal still has a shortcoming in that it is not easy to determine the cost of capital The third proposal may be effective based on the degree of competition that may be posed on the managers across the board. Murphy’s performance if evaluated by comparing the RIs of other firms, the benefit of this is that it will improve the performance of Murphy over a period of time and this would mean his compensation will not be based on ROI and RI of WD. The disadvantage of this is that it is not an effective way of evaluating performance since firms have different capital and cost structures. 2. I would recommend the second proposal where Murphy’s compensation is based on the division IR. This is of benefit even to the firm since investment decisions on whether to accept or not will be based on the residual income that will be realized from the investment. Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(Analysis of Cash and Credit Sales, Debt Collection, Cash Collected from Credit Sales Assignment Example | Topics and Well Written Essays - 2750 words, n.d.)
Analysis of Cash and Credit Sales, Debt Collection, Cash Collected from Credit Sales Assignment Example | Topics and Well Written Essays - 2750 words. https://studentshare.org/finance-accounting/2071197-no-topic-for-this-assignment-just-solusion-a-quetions
(Analysis of Cash and Credit Sales, Debt Collection, Cash Collected from Credit Sales Assignment Example | Topics and Well Written Essays - 2750 Words)
Analysis of Cash and Credit Sales, Debt Collection, Cash Collected from Credit Sales Assignment Example | Topics and Well Written Essays - 2750 Words. https://studentshare.org/finance-accounting/2071197-no-topic-for-this-assignment-just-solusion-a-quetions.
“Analysis of Cash and Credit Sales, Debt Collection, Cash Collected from Credit Sales Assignment Example | Topics and Well Written Essays - 2750 Words”. https://studentshare.org/finance-accounting/2071197-no-topic-for-this-assignment-just-solusion-a-quetions.
  • Cited: 0 times

CHECK THESE SAMPLES OF Analysis of Cash and Credit Sales, Debt Collection, Cash Collected from Credit Sales

Financial Analysis of Marvel Toys Pvt Ltd

Financial analysis of Marvel Toys Pvt.... In APA Format By Abstract Executive summary, Introduction, Discussion, Complete Financial analysis of the Firm covering Cash Flow Analysis, Ratio Analysis, Analysis from a Long Term Creditor's point of view, Examining the Collateral Security offered by the Firm, Recommendation to the Loan Granting Bank, Other Factors to be Considered, Conclusion, Decisions, References, Presentation.... The current document dwells into the complete financial analysis of the organization....
12 Pages (3000 words) Research Paper

Sales on Credit

As a result, companies focus on more credit sales to improve sales, ensure attainment of success with the intense competition among business firms while offering the customers with flexible terms of payment that suit them.... However, there is always a need for receivables management in organizations that issue credit sales.... In most cases, companies carry out credit analysis of the respective clients who wish to be issued goods and services on credit as a way of being assured that the amount of money owed would be paid....
5 Pages (1250 words) Research Paper

Role of Secured Creditors in Business Insolvency

14 Pages (3500 words) Essay

Financial Management and Factoring

percent of annual credit sales and saving the cost of trade debt financing through better collection. ... n analysis of our current practices in this aspect of financial management has revealed the following problems:Trade receivables have increased from the desired thirty days to the actual fifty days.... percent of total sales.... percent of sales, for trade debt or receivables financing, bad debts, and overhead.... percent from the present to 1....
11 Pages (2750 words) Essay

Managing and accounting for financial resources

evolving credit - Revolving credit is a special alternative banking system designed for the farmers and other unorganized segments of the society.... Banks also provide indirect assistance in the form of ‘Letter of credit'.... A letter of credit is an arrangement whereby the bank helps its customer to obtain credit from the customer's suppliers.... The bank, by opening a letter of credit, undertakes the responsibility to honour the obligation of its customer in case the customer fails to do so....
12 Pages (3000 words) Essay

Accounting

f Allowance for Doubtful Accounts has a credit balance of $2,100 in the trial balance, journalize the adjusting entry at December 31, assuming bad debts are expected to be (1) 1% of net sales, and (2) 10% of accounts receivable.... 5% of net sales and (2) 6% of accounts receivable.... estimated that 2% of its net sales of $400,000 will become uncollectible.... (For multiple debit/credit entries, list amounts.... credit card to purchase merchandise from Pierson Co....
5 Pages (1250 words) Assignment

Ford Motor Company: Audit Risk Analysis

While on the other hand Financial Services includes its credit Company and Other many other Financial Services.... n the Ford Motor credit Company take account of financing vehicle-related issues, insurance, leasing, lastly Other Financial Services Contains a diversity of businesses like holding real estate and companies.... n 2009, the Board again voluntarily forgoes the cash portion of annual fees.... Directors failed to receive any cash payments comparative to the board fees in 2009....
7 Pages (1750 words) Research Paper

Analysis of Working Capital

From this paper, it is clear that analysis of working capital gives the indication of effective use of the firm's assets and ability to pay upcoming debts and expenses of the firm.... A firm needs to figure out the optimal level of its stocks and inventory by keeping in view its sales requirements, the product, cost of storing along with the strength of its procurement and supply change.... The simplest Working Capital Cycle starts with the purchase of stock from a supplier on credit followed by the selling of finished goods to the buyers on credit and Cash....
8 Pages (2000 words) Research Paper
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Contact Us