Information regarding budgeted sales

Assignment Help Accounting Basics

Reference no: EM131068499

Timpco, a retailer, makes both cash and credit sales (i.e., sales on open account). Information regarding budgeted sales for the last quarter of the year is as follows:

	October	November	December
Cash Sales	$100,000	$120,000	$80,000
Credit Sales	$100,000	$150,000	$90,000
Total	$200,000	$270,000	$170,000

Past experience shows that 5% of credit sales are uncollectible. Of the credit sales that are collectible, 60% are collected in the month of sale; the remaining 40% are collected in the month following the month of sale. Customers are granted a 1.5% discount for payment within 10 days of billing. Approximately 75% of collectible credit sales take advantage of the cash discount.

Inventory purchases each month are 100% of the cost of the following month's projected sales. (The gross profit rate for Timpco is approximately 30%.) All merchandise purchases are made on credit, with 25% paid in the month of purchase and the remainder paid in the following month. No cash discounts for early payment are in effect.

Required - Please explain the math used.

1. Calculate the budgeted total cash receipts for November and December.

2. Calculate budgeted cash payments for November and December (budgeted total sales for January of the coming year 5 $200,000).

Reference no: EM131068499

Questions Cloud

Negative outcome of the reverse : What would be the likely negative outcome if a marketing plan paid a lot of attention to strategies and little attention to tactics? What would be the likely negative outcome of the reverse?

Explain the benefits accrued to a firm : Explain the benefits accrued to a firm that is guided by the principles of business ethics.

Limit the maximum temp gradient in the glass : Plate glass, k= 1.35W/m*K, initiallly at 850K, is cooled by blowing air past both surfaces with an effective surface coeffiicent of 5 W/m^2*K. It is necessary, in order that the glass not crack, to limit the maximum temp gradient in the glass to 1..

Find the probability that exactly 50 will be heads : Generate aprobability histogramof the number of rolls required of two dice before a sum of "7" appears (graphical answer followed by MATLAB code). The MATLAB code should simulate the results of 10,000 experiments of rolling the dice.

Information regarding budgeted sales : Timpco, a retailer, makes both cash and credit sales (i.e., sales on open account). Information regarding budgeted sales for the last quarter of the year is as follows:

How adding bagel sandwiches change mountain bagels profit : How would adding bagel sandwiches change Mountain Bagels' profit? What information would you need before you can determine how introducing bagel sandwiches would affect Mountain Bagels' overall profit?

Write a particular specification for a cut-to-fill earthwork : Note that the project specification will include a geotechnical report and a series of drawings giving all dimensions, slopes, etc

What were the trial court findings in miranda : What factors do you believe the trial court took into consideration when they decided Miranda? Did the Connecticut Supreme Court uphold the trial court's decision?

Explain your monthly master budget and the items included : Explain your monthly master budget and the items included in it, and compare these planned items against what you spent on them last month.

User Account

All Pages