preview

Case Study: Master Budgeting with Supporting Schedule

Decent Essays

CASE 8–29 Master Budget with Supporting Schedules

Cravat Sales Company, a nationwide distributor of a designer’s silk ties with an exclusive franchise on the distribution of the ties, and sales have grown rapidly over the last few years. Your have been given responsibility for all planning and budgeting.

Your assignment is to prepare a master budget for the next 3 months, starting April 1st. You are anxious to make a favorable impression on the president and have assembled the information below.

The company desires a minimum ending cash balance each month of $10,000. The ties are sold to retailers for $8 each. Recent and forecasted sales in units are as follows:

The large buildup in sales before and during June is due to Father’s …show more content…

Otherwise, it would go bankrupt from liquidity problem, regardless of how good the sales performed.

To survive from bankruptcy, we would suggest the management team to improve cash cycle, in order to maintain enough cash for operations.

Scenario 1: Negotiation with both customers and suppliers

We preferred these new terms of payment (Table 3) over the old ones.

Table 3 – Cravat Sales Company
Liquidity Improvement Proposals

We shall offer a 5% discount of selling price, in order to achieve the goal with retailers. Thus, selling price per unit in this quarter shall be dropped into $7.60
Our suggestions, if execute successfully, the newly forecasted cash scenario would be improved as Table 4, 5.

Table 4 – Cravat Sales Company
Expected cash collections, and cash disbursements for merchandise purchases (Scenario 1)

Unit: USD

The change to expected cash payments was observed easily. In April, instead of spending as much as $195,750 for merchandises purchasing, the company paid $173,750 only. In the quarter, amount of cash spending decreased from $703,250 to $682,250 ($21,000 less), while the change to expected cash collections can make the company obtain much more cash, said to be $932,300 from $886,000 ($46,300 more).

Table 5 – Cravat Sales Company Cash Budget (Scenario 1) Unit: USD

* the interest rate was

Get Access