Question

In: Accounting

December of the previous year 50,000, January70,000, February 100,000, March60,000, April100,000.


December of the previous year 50,000, January70,000, February 100,000, March60,000, April100,000. Past experience shows that 45% of sales are collected in the month of the sale, and 55% in the month following the sale.

    2. Prepare a purchases budget for January through March, and the first quarter in total. Assume that the company only sells one product that can be purchased at $35.00 per unit. The market for this product is very competitive and customers highly value service such as quality and on time delivery of the product. Also assume that currently it is company policy that ending inventory should equal 45% of next month’s projected sales. All costs are paid in the current month except inventory purchases, which are paid in the month following the purchase (i.e. January purchases are paid in February).

3. Prepare a cash budget for January through March and for the first quarter in total. The company maintains a minimum cash balance of $70,000, and this was the balance in the cash account on January 1st. Other expenses include $35,000 per month for rent, $24,000 per month for advertising, and $66,000 per month for depreciation. In addition, variable Selling & Administrative cost is $12 per unit sold, and the company paid a $20,000 dividend in February.

The company has an open line of credit with a bank and can borrow at an annual rate of 12%.
For simplification assume that all loans are made at the beginning of the month when borrowing is needed, and repayments are made at the end of a month if there is enough cash to make the payment. Also, interest associated with a loan is only paid at the time when that loan or a portion thereof is paid. Additionally, all loans and repayments (not the interest portion) can only be made in increments of $1000 and the company would like to pay its debts, or a portion thereof, as soon as it has enough cash to do so.

Budgeted unit sales            50,000            70,000         100,000            60,000             230,000         100,000
Selling price per unit $50.00 $50.00 $50.00 $50.00 $50.00 $50.00
Total sales $2,500,000 $3,500,000 $5,000,000 $3,000,000 $11,500,000 $5,000,000
             
             
    Scheduled of Expected Cash Collections  
    January February March Total  
Beginning accounts receivable (December) $750,000          
January            
February            
March            
Total cash collection            
  December January February March Total
Budgeted unit Sales          50,000                 70,000               100,000                 60,000               230,000
Add desired ending merchandise inventory          35,000                 45,000                 27,000                 45,000               117,000
Total needs                 120,000               130,000               110,000               360,000
Less beginning merchandise inventory                   31,500                 45,000                 27,000               103,500
Required purchases                    -                    88,500                 85,000                 83,000               256,500
           
Unit product cost $        35.00 $               35.00 $               35.00 $               35.00 $               35.00
Cost of inventory purchases $               -    $       3,097,500 $       2,975,000 $       2,905,000 $       8,977,500
           
   
  Budgeted cash disbursements for merchandise purchases:
  For the first quarter ended March 2020
  Quarter 1
    January February March Total
Beginning accounts payable (December)          
January purchases          
February purchases          
March purchases          
Total cash disbursements for merchandise purchases   $                      -    $                      -    $                      -    $                      -   
Beginning cash balance
add cash receipts
Cash collections from customers
Total cash available
Less cash disbursements
Total cash disbursements for merchandise purchases
Cash from Selling and administrative
Dividend
Total cash disbursements
Excess (deficiency) of cash available over disbursements
Financing
Borrowing (at the beginnings of the month)
Repayments (at end of the month)
Interest
Total financing
Ending cash balance

Solutions

Expert Solution

Sales Budget
Particulars December January February March Quarter April
Budgeted sales (in units) 50000 70000 100000 60000 230000 100000
Selling price per unit $               50.00 $               50.00 $               50.00 $                 50.00 $                 50.00 $               50.00
Budgeted sales $ 2,500,000.00 $ 3,500,000.00 $ 5,000,000.00 $    3,000,000.00 $ 11,500,000.00 $ 5,000,000.00
Schedule of expected cash collectuons
Particulars January February March Quarter
Budgeted sales $ 3,500,000.00 $ 5,000,000.00 $ 3,000,000.00
Collection for :
December $ 1,375,000.00 $    1,375,000.00
January $ 1,575,000.00 $ 1,925,000.00 $    3,500,000.00
February $ 2,250,000.00 $ 2,750,000.00 $    5,000,000.00
March $ 1,350,000.00 $    1,350,000.00
Total Collections $ 2,950,000.00 $ 4,175,000.00 $ 4,100,000.00 $ 11,225,000.00
Workings:
Collection on the month of January for:
December ($ 2500000 x 55%) $ 1,375,000.00
January ($ 3500000 x 45%) $ 1,575,000.00
$ 2,950,000.00
Collection on the month of February for:
January ($ 3500000 x 55%) $ 1,925,000.00
February ($ 5000000 x 45%) $ 2,250,000.00
$ 4,175,000.00
Collection on the month of March for:
February ($ 5000000 x 55%) $ 2,750,000.00
March ($ 3000000 x 45%) $ 1,350,000.00
$ 4,100,000.00
Merchandise Purchase Budget
Particulars December January February March Quarter April
Budgeted sales (in units) 50000 70000 100000 60000 230000 100000
Add: Desired ending inventory 31500 45000 27000 45000 117000
Total Needs 81500 115000 127000 105000 347000
Less: Beginning inventory 22500 31500 45000 27000 103500
Required purchase 59000 83500 82000 78000 243500
Unit product cost $               35.00 $               35.00 $               35.00 $               35.00 $            105.00
Cost of inventory purchase $ 2,065,000.00 $ 2,922,500.00 $ 2,870,000.00 $ 2,730,000.00 $ 8,522,500.00
Schedule of expected cash disbursements for merchandise purchase
Particulars January February March Quarter
Payment for the month of:
December $ 2,065,000.00 $ 2,065,000.00
January $ 2,922,500.00 $ 2,922,500.00
February $ 2,870,000.00 $ 2,870,000.00
Total payment $ 2,065,000.00 $ 2,922,500.00 $ 2,870,000.00 $ 7,857,500.00
Cash Budget
January February March
Beginning cash balance $       70,000.00 $       70,000.00 $         70,000.00
add cash receipts
Cash collections from customers $ 2,950,000.00 $ 4,175,000.00 $    4,100,000.00
Total cash available $ 3,020,000.00 $ 4,245,000.00 $    4,170,000.00
Less cash disbursements
Total cash disbursements for merchandise purchases $ 2,065,000.00 $ 2,922,500.00 $    2,870,000.00
Cash from Selling and administrative $     840,000.00 $ 1,200,000.00 $       720,000.00
Dividend $                     -   $       20,000.00 $                        -  
Other expenses $       59,000.00 $       59,000.00 $         59,000.00
Total cash disbursements $ 2,964,000.00 $ 4,201,500.00 $    3,649,000.00
Excess (deficiency) of cash available over disbursements $       56,000.00 $       43,500.00 $       521,000.00
Financing
Borrowing (at the beginnings of the month) $       14,000.00 $       26,500.00
Repayments (at end of the month) $                     -   $                     -   $        (40,500.00)
Interest $                     -   $                     -   $             (545.00)
Total financing $       14,000.00 $       26,500.00 $        (41,045.00)
Ending cash balance $       70,000.00 $       70,000.00 $       479,955.00

Related Solutions

Assume the following: Cash, $100,000; Accounts Receivable, $50,000; Accounts Payable, $50,000; Supplies, $40,000; Equipment, $100,000; Land,...
Assume the following: Cash, $100,000; Accounts Receivable, $50,000; Accounts Payable, $50,000; Supplies, $40,000; Equipment, $100,000; Land, $500,000; Bonds Payable, $1,000,000; Mortgage Payable, $400,000; Inventory, $100,000. Compute both the current and quick ratios. What conclusions can you draw from this data ?
Suppose America is able to produce up to 100,000 computers/year or 50,000 TVs/year or any linear combination of the two.
Suppose America is able to produce up to 100,000 computers/year or 50,000 TVs/year or any linear combination of the two. Japan is able to produce up to 80,000 computers/year or 160,000 TVs/year or any linear combination of the two. Assume that without trade, each country spends half of their efforts on each good.Which country has the absolute advantage in each good?   A. America has the absolute advantage in both computers and TVs.   B. Japan has the absolute advantage...
During February 2019 Festus insured his Renault car with Provident. In the previous year, two events had occurred.
During February 2019 Festus insured his Renault car with Provident. In the previous year, two events had occurred. A car accident which his girlfriend (driving her own car) had suffered a fractured leg as a named driver and which had been declared to the insurers and was settled satisfactorily and secondly, Festus had been convicted for drunk driving and negligent driving. In May 2019 Festus changed his Renault for a BMW and was charged an additional premium. He did not...
On February 1, Willmar Corporation borrowed $100,000 from its bank by signing a 12 percent, 15-year...
On February 1, Willmar Corporation borrowed $100,000 from its bank by signing a 12 percent, 15-year note payable. The note calls for 180 monthly payments of $1,220. Each payment includes an interest and a principal component. a. Compute the interest expense in February. b. Compute the portion of Willmar’s March 31 payment that will be applied to the principal of the note. (Round your intermediate calculations and final answer to the nearest dollar amount.) c. Compute the carrying value of...
(Show work and Calculations) On February 1, 2011, M&N company issued $100,000 of 5 year bonds,...
(Show work and Calculations) On February 1, 2011, M&N company issued $100,000 of 5 year bonds, paying 8% interest every July 31 and January 31. The bonds sold for $92,278 reflecting the market rate at the time of 10%. Prepare all bond related journal entries that M&N should have recorded through January 31, 2012, the date of the second interest payment, supported by an amortization schedule covering that same 12-month period. Do not recalculate issuance proceeds.
An employee earned $4,600 in February working for an employer. Cumulative earnings of the previous pay...
An employee earned $4,600 in February working for an employer. Cumulative earnings of the previous pay periods are $4,800. The FICA tax rate for Social Security is 6.2% of the first $127,200 of earnings each calendar year and the FICA tax rate for Medicare is 1.45% of all earnings. The current FUTA tax rate is 0.6%, and the SUTA tax rate is 5.4%. Both unemployment taxes are applied to the first $7,000 of an employee’s pay. What is the amount...
An employee earned $4,600 in February working for an employer. Cumulative earnings of the previous pay...
An employee earned $4,600 in February working for an employer. Cumulative earnings of the previous pay periods are $4,800. The FICA tax rate for Social Security is 6.2% of the first $127,200 of earnings each calendar year and the FICA tax rate for Medicare is 1.45% of all earnings. The current FUTA tax rate is 0.6%, and the SUTA tax rate is 5.4%. Both unemployment taxes are applied to the first $7,000 of an employee’s pay. What is the amount...
Part 2 Computer Accessories assembles a computer Beginning-of-year balances Cash $50,000 Accounts receivables (previous quarter's sales)...
Part 2 Computer Accessories assembles a computer Beginning-of-year balances Cash $50,000 Accounts receivables (previous quarter's sales) $61,200 Raw materials 653 Kits Finished Goods 510 Units Accounts payable $33,255 Desired end-of-year inventory balances Raw materials 500 kits Finished goods 270 units Desired end-of-quarter balances Raw materials as a portions of the following quarter's production 20% Finished goods as a portion of the following quarter's sales 15% Manufacturing costs other than raw materials are paid in month incurred unless it is an...
PINNACLE PLUS Horizontal Analysis Increase (Decrease) in the Current year (versus Previous year) Current Year Previous...
PINNACLE PLUS Horizontal Analysis Increase (Decrease) in the Current year (versus Previous year) Current Year Previous Year Amount Percentage Income Statement Sales Revenue $120,000 $106,000 % Cost of Goods Sold 54,000 49,000 Gross Profit 66,000 57,000 Operating Expenses 41,000 35,500 Interest Expense 5,000 5,000 Income before Income Tax Expense 20,000 16,500 Income Tax Expense (30%) 6,000 4,950 Net Income $14,000 $11,550 % Balance Sheet Cash $77,900 $43,000 % Accounts Receivable, Net 19,000 10,000 Inventory 26,000 40,000 Property and Equipment, Net...
On December 29, year 7, Almond Company granted 100,000 stock options to a group of 100...
On December 29, year 7, Almond Company granted 100,000 stock options to a group of 100 employees, enabling each employee to buy 1,000 shares for $20 per share. On the grant date, the shares had a market value of $16 per share and the options had a market value of $3.00 per option. The options vest over a 3-year period and become exercisable on January 1, year 11. Almond Company expects that, based on historical turnover, they will lose approximately...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT