Question

Only a Game Inc. Cash Budgeting This really is great! We’ve only been producing the “Sticky...


Only a Game Inc.

Cash Budgeting

This really is great! We’ve only been producing the “Sticky Fingers” for six months and look at the profits. Sales projections for the future go nowhere but up, up, up! I’m going to take my family on a well-deserved vacation. They’ve put up with a lot; I haven’t been home much at all getting this started. We need some quality time together. All this hectic activity has left me mighty tired, so a break would do me a lot of good right now.

T. L. Tina T. Rollt, President and Founder, Only a Game

Tina Rollt (her parents got a little carried away with names, giving her many problems when she was in school) founded her company in late 2002. She had worked as a product designer for a well-known toy company, developing new toys and games in keeping with the fashions of the times. Tina thought she’d like to market some of her better ideas herself and decided to invest her savings in founding a new company. She converted her savings into common stock, and taking the simple approach, she called the company Only a Game. Their first hit toy was a puzzle called “Sticky Fingers,” a handheld electronic puzzle requiring both dexterity and thinking skills.

Each Sticky Fingers costs the company $14 to produce. In addition to these production costs that vary in direct proportion to volume, the company also incurs $4,000 monthly costs just to be in business, irrespective of the month’s volume. Sticky Fingers sells to retailers for $22 each.

As of December 31, 2002, only a Game had been producing Sticky Fingers for three months, using rented facilities. The balance sheet on December 31 looked as follows:

Only a Game Company

Balance Sheet

December 31, 2002

Assets

Cash                                                               $56,500

Accounts receivable                                          27,500

Inventory                                                         14,000

            Total assets                                        $98,000

Equities

Common Stock                                              $100,000

Retained earnings                                               -2000

            Total equities                                     $98,000

Rollt was very pleased to be operating at a profit in such a short time. December sales had been 750 units, up from 500 in November, enough to report a profit for the month and to reduce the deficit accumulated in October and November. Sales were projected to be 1,000 units in January, and Rollt’s projections showed sales increases of 500 units per month after that. Thus, by May, monthly sales were expected to be 3,000 units. By September, that figure would be 5,000 units.

Rollt was very conscious of the importance of developing good sales channel relationships in order to increase sales, so Sticky Fingers’ deliveries were always prompt. This required production to be scheduled 30 days in advance of predicted sales. For example, only a Game produced 1,000 Sticky Fingers in December in anticipation of January sales, and planned to produce 1,500 in January for February’s anticipated demand.

The company billed its customers with stated terms of 30 days net but had not spent a lot of effort in enforcing these credit terms, with the result that customers appeared to actually be taking an additional month to pay. All of the company’s costs (production and operating) were paid in cash in the month they were incurred.

Tina’s projections were accurate. By March, sales had reached 2,000 Sticky Fingers, and 2,500 were produced in March for April sale. Total profit for the first quarter of the year 2003 (the end of March) had reached $24,000. In order to get a respite from what had been a very hectic 6 month getting her business started, Tina decided to take her family on a much-deserved vacation in early April (see above).

Tina had hardly been gone for a week when her cell phone rang. It was her bookkeeper, who was in a panic. The company’s bank balance was nearly at zero, so materials needed for April production could not be purchased. Unless Tina returned immediately to raise more cash, the entire operation would grind to a halt within a few days.  

?

Only a Game Inc.
              Unit information
Unit cost
Unit selling price
Monthly operating costs
Month October November December January February March April May June July August September October November
production in units
sales in units
Month October November December January February March April May June July August September October November
Income statements:
Sales
Cost of sales
Operating expenses
Net operating income
Collections budget:
Beginning accounts receivable
Collections
Current sales
Ending accounts receivable
Production budget:
Units produced
Cash required
Cash budget:
Beginning balance
Add collections
Less production & operating costs
Excess (deficit) cash to costs
Borrowings
Repayments
Ending balance
Balance sheets:
Cash
Accounts receivable
Inventory
Total assets
Liabilities
Common stock
Retained earnings
Total equities

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Mitchell Company had the following budgeted sales for the first half of next year:    Cash...
Mitchell Company had the following budgeted sales for the first half of next year:    Cash Sales Credit Sales   January $70,000        $170,000        February $75,000        $190,000        March $32,000        $150,000        April $37,000        $132,000        May $47,000        $220,000        June $100,000        $220,000         The company is in the process of preparing a cash budget and must determine the expected cash collections by month. To this end, the following information has been assembled:      Collections on credit sales:   50% in...
Cash Budget The controller of Dash Shoes Inc. instructs you to prepare a monthly cash budget...
Cash Budget The controller of Dash Shoes Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: March April May Sales $145,000 $180,000 $247,000 Manufacturing costs 61,000 77,000 89,000 Selling and administrative expenses 42,000 49,000 54,000 Capital expenditures _ _ 59,000 The company expects to sell about 15% of its merchandise for cash. Of sales on account, 60% are expected to be collected in the month following the...
Cash Budget The controller of Dash Shoes Inc. instructs you to prepare a monthly cash budget...
Cash Budget The controller of Dash Shoes Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: March April May Sales $115,000 $148,000 $194,000 Manufacturing costs 48,000 64,000 70,000 Selling and administrative expenses 33,000 40,000 43,000 Capital expenditures _ _ 47,000 The company expects to sell about 12% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the...
I ONLY NEED THE INVENTORY PURCHASES BUDGET (C) AND THE CASH BUDGET (G). Hint - not...
I ONLY NEED THE INVENTORY PURCHASES BUDGET (C) AND THE CASH BUDGET (G). Hint - not all the numbers in the two charts just get added across. I'm assuming that is to find the total-qtr. number. Please help! Admire is a retail company that sells specialized gardening products. The company is considering opening a new store on October 1, Year1. As budget coordinator, you have been asked to prepare a master budget for the first 3 months of the company’s...
KING KARS You begin the year with a cash balance of $50,000, and the minimum cash...
KING KARS You begin the year with a cash balance of $50,000, and the minimum cash balance desired must be $50,000 every month. Prepare a cash ow summary and external financing summary as noted in Excel spreadsheet. JANUARY FEBRUARY MARCH APRIL MAY JUNE JULY AUGUST SEPTEMBER OCTOBER NOVEMBER DECEMBER GIVEN: MONTHLY NET CASH GAIN OR LOSS $5,000 $(30,000) $20,000 $(35,000) $25,000 $(10,000) $25,000 $25,000 $(30,000) $15,000 $15,000 $25,000 JANUARY FEBRUARY MARCH APRIL MAY JUNE JULY AUGUST SEPTEMBER OCTOBER NOVEMBER DECEMBER...
At the beginning of September, L Company had 1,600 finished goods units. Budgeted sales for October,...
At the beginning of September, L Company had 1,600 finished goods units. Budgeted sales for October, November, December, and January are 8,400 units and 10,200 units and 13,600 units and 7,400 units respectively. L Company wants to have sufficient units on hand at the end of each month to meet 20 percent of the following month’s budgeted sales. Prepare a Production Budget with columns for October, November, December and Total 4th Quarter.
The following data have been taken from the budget reports of Kenyon Company, a merchandising company....
The following data have been taken from the budget reports of Kenyon Company, a merchandising company. Purchases Sales January $ 190,000 $ 130,000 February $ 190,000 $ 230,000 March $ 190,000 $ 270,000 April $ 170,000 $ 330,000 May $ 170,000 $ 290,000 June $ 150,000 $ 270,000 Forty percent of purchases are paid for in cash at the time of purchase, and 30% are paid for in each of the next two months. Purchases for the previous November and...
Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget...
Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: September October November Sales $101,000 $126,000 $169,000 Manufacturing costs 42,000 54,000 61,000 Selling and administrative expenses 35,000 38,000 64,000 Capital expenditures _ _ 41,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the...
Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget...
Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: September October November Sales $139,000 $167,000 $231,000 Manufacturing costs 58,000 72,000 83,000 Selling and administrative expenses 49,000 50,000 88,000 Capital expenditures _ _ 55,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the...
Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget...
Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: September October November Sales $106,000 $137,000 $173,000 Manufacturing costs 45,000 59,000 62,000 Selling and administrative expenses 37,000 41,000 66,000 Capital expenditures _ _ 42,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the...