Question

Question 1. Prepare a budget for this year for the Administrative Department at Tom’s Toyota Company...

Question 1. Prepare a budget for this year for the Administrative Department at Tom’s Toyota Company based on the following information:

                                    Last Year        Forecasting Assumption         Budget for this Year

            Salaries            $75,000           2% increase                             ___________

            Stationary        $     900           1% decrease                            ___________

            Telephone        $ 2,000           3% increase                            ___________

            Electricity        $ 3,000           2.5% increase                        ___________

            Office Rent     $12,000           2% increase                            ___________

            Depreciation    $ 4,000           no change                                ____________

                        Total: $96,900                                   

Question 7. Webster’s Discount Appliances expects sales of $5,000, $5,000, and $10,000 during April, May, and June (big sale in June). To build business, Webster let’s all customers buy on credit, and all do so. In the past, 15% of Big Bob's sales have been collected during the month of sale, 70% are collected the following month, and 10% the month after that. If this trend continues, what will be Webster’s total cash collections in the month of June?

Question 8. Little Louie’s expects to have $100 in cash on hand at the beginning of June, and the company's target cash balance is $100. Net cash flow for June is minus $300. Assuming that Little Louie’s borrows to meet short‑term cash needs and pays back as soon as surplus cash is available, what will be the company's ending cash balance after financing at the end of June?

Homework Answers

Answer #1

Dear Student, only one question is allowed at a time. I am answering the first question

1)

Calculations A B C = 1 + B D = A x C
Particulars Last Year Forecasting Assumption Nature of Forecasting Multiplying Factor Forecasted Value
Salaries    75000 2.00% Increase 1.020 76500
Stationary 900 -1.00% Decrease 0.990 891
Telephone 2000 3.00% Increase 1.030 2060
Electricity 3000 2.50% Increase 1.025 3075
Office Rent   12000 2.00% Increase 1.020 12240
Depreciation 4000 0.00% No Change 1.000 4000
Total 98766
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
Caba Corporation’s sales budget for the first half of the year is as follows: Budgeted Sales...
Caba Corporation’s sales budget for the first half of the year is as follows: Budgeted Sales January $ 115,000 February $ 198,000 March $ 220,000 April $ 250,000 May $ 210,000 June $ 290,000 Total: $ 1,283,000 Sales are 30% cash and 70% on account. Sales on account are to be collected over a three-month period, with 20% collected in the month of the sale, 65% collected in the first month following the sale, and 15% collected in the second...
You have been asked to prepare a December cash budget for Ashton Company, a distributor of...
You have been asked to prepare a December cash budget for Ashton Company, a distributor of exercise equipment. The following information is available about the company’s operations: The cash balance on December 1 is $58,600. Actual sales for October and November and expected sales for December are as follows: October November December Cash sales $ 73,200 $ 78,000 $ 92,000 Sales on account $ 485,000 $ 568,000 $ 663,000 Sales on account are collected over a three-month period as follows:...
You have been asked to prepare a December cash budget for Ashton Company, a distributor of...
You have been asked to prepare a December cash budget for Ashton Company, a distributor of exercise equipment. The following information is available about the company’s operations: The cash balance on December 1 is $53,400. Actual sales for October and November and expected sales for December are as follows: October November December Cash sales $ 77,000 $ 81,200 $ 87,800 Sales on account $ 435,000 $ 538,000 $ 644,000 Sales on account are collected over a three-month period as follows:...
Cash Budget The owner of a building supply company has requested a cash budget for June....
Cash Budget The owner of a building supply company has requested a cash budget for June. After examining the records of the company, you find the following: Cash balance on June 1 is $1,186. Actual sales for April and May are as follows: April May Cash sales $10,000 $18,000 Credit sales 28,900 35,000 Total sales $38,900 $53,000 Credit sales are collected over a 3-month period: 40% in the month of sale, 30% in the second month, and 20% in the...
Cash Budget The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget...
Cash Budget The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: May June July Sales $128,000 $155,000 $216,000 Manufacturing costs 54,000 67,000 78,000 Selling and administrative expenses 37,000 42,000 48,000 Capital expenditures _ _ 52,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 60% are expected to be collected in the month following the...
Little Flower Establishment would like to prepare a cash budget for July and August. The following...
Little Flower Establishment would like to prepare a cash budget for July and August. The following information has been gathered:        (i) Cash balance as of July 1: $ 1,440,000        (ii) Forecasted sales are as follows:                                                       May                June               July             August Cash sales............................ $1,600,000    $ 1,920,000    $ 1,920,000    $ 1,920,000 Credit sales..........................  1,280,000      1,440,000       1,600,000       1,920,000 Total..................................... $ 2,880,000    $ 3,360,000     $ 3,520,000     $ 3,840,000        (iii) Credit sales are collected 40% in the month of the sale, 35%...
Use the following information to prepare a cash budget for Knightsbridge Corporation for the month of...
Use the following information to prepare a cash budget for Knightsbridge Corporation for the month of June 2020. In May, credit sales were $175,000; 80% of this amount is estimated to be collectible in June. June sales are estimated to be $340,000, all of which are credit sales. Only 20% of credit sales are collected in the month in which the sale is made. Total fixed expenses are $60,000 per month, including $26,000 depreciation. Variable expenses are 35% of sales....
Cousins Corporation is a merchandising company that is preparing a master budget for the third quarter...
Cousins Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet as of June 30th is shown below: Cousins Corporation Balance Sheet June 30 Assets Cash $ 81,000 Accounts receivable 132,000 Inventory 56,250 Plant and equipment, net of depreciation 214,000 Total assets $ 483,250 Liabilities and Stockholders’ Equity Accounts payable $ 75,000 Common stock 346,000 Retained earnings 62,250 Total liabilities and stockholders’ equity $ 483,250 The company...
The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget for the...
The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: May June July Sales $90,000 $108,000 $148,000 Manufacturing costs 38,000 46,000 53,000 Selling and administrative expenses 26,000 29,000 33,000 Capital expenditures _ _ 36,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 sale and...
Flexible Budget for Selling and Administrative Expenses for a Service Company Morningside Technologies Inc. uses flexible...
Flexible Budget for Selling and Administrative Expenses for a Service Company Morningside Technologies Inc. uses flexible budgets that are based on the following data: Sales commissions 7% of sales Advertising expense 25% of sales Miscellaneous administrative expense $1,850 per month plus 3% of sales Office salaries expense $17,000 per month Customer support expenses $2,600 plus 4% of sales Research and development expense 5,750 per month Prepare a flexible selling and administrative expenses budget for April for sales volumes of $115,000,...