Schedule of Cash Payments Tadpole Learning Systems Inc. was organized on February 28. Projected selling and administrative expenses for each of the first three months of operations are as follows: March $120,000 April 140,000 May 160,000 Depreciation, insurance, and property taxes represent $10,000 of the estimated monthly expenses. The annual insurance premium was paid on February 28, and property taxes for the year will be paid in November. Seventy percent of the remainder of the expenses are expected to be paid in the month in which they are incurred, with the balance to be paid in the following month. Prepare a schedule indicating cash payments for selling and administrative expenses for March, April, and May. Enter all amounts as positive numbers.

Solution :

                            Tadpole Learning System Inc.

     Schedule of cash payments for selling and administration expenses

                           For the three months ending May 31

Particulars                      March                     April                       May

March Expenses

Paid in March              $ 77,000

Paid in April                                               $ 33,000

                              ($110000 x 70%)     ($110000 x 30%)

April Expenses

Paid in April                                            $ 91,000                  

Paid in May                                                                                 $ 39,000                                                      

                                                             ($130000 x 70%)     ($130000 x 30%)

May expenses

Paid in May                                                                                $ 1,05,000

                                                                                              ($150000 x 70%)

Total cash payments  $ 77,000              $ 1,24,000            $ 1,44,000    

Given the expenses including depreciation, insurance and property tax of 10,000 to be deducted as it is not paid in the months of March, April, May. Hence it is excluded :

1                                   2                       3                                               2-3

Revised expense   Expense   Depreciation, insurance    Expense excluding

                                                 property tax                      depreciation,  

                                                                                            insurance and

                                                                                            property tax

March                     $ 1,20,000         $ 10,000                       $ 1,10,000

April                        $ 1,40,000         $ 10,000                       $ 1,30,000

May                        $ 1,60,000         $ 10,000                       $ 1,50,000

a manufacturer of printed circuit boards uses exponential smoothing with trend to forecast monthly demand of its product. at the end of december, the company wishes to forecast sales for january. the estimate of trend through november has been 200 additional boards sold per month. average sales have been around 1000 units per month. the demand for december was 1100 units. the company uses α = 0.20 and β = 0.10. make a forecast including trend for the month of january.