Kessler Service anticipates the following sales - 99987

Solution Posted by
yousafbhutta

yousafbhutta

Rating : (29)C
Solution Detail
Price: $5.00
  • From: ,
  • Posted on: Sun 31 Mar, 2019
  • Request id: None
  • Purchased: 0 time(s)
  • Average Rating: No rating
Request Description
Kessler Service anticipates the following sales revenue over a five-month period: November December January February March Sales revenue $16,500 $11,200 $15,200 $13,200 $14,400 The company’s sales are 30% cash 70% credit Its collection history indicates that credit sales are collected as follows: 25% in the month of the sale 50% in the month after the sale 20% two months after the sale 5% are never collected Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instruction tab you will be marked wrong.? Requirement How much cash will be collected in January? In February? In March? For the quarter in total?
Solution Description

Kindly download file