Question

In: Finance

Assume Cindy has cash on hand of $550 at the beginning of March.

Assume Cindy has cash on hand of $550 at the beginning of March. Her monthly salary (take home) is $1,800. Her expenses are as follows: Rent $650, utilities $125, Telephone, cable and internet $90, food and clothing $300. In April, she expects to get tax refund of $240. In May, she plans to take a short vacation with cost of $450. Prepare Cindy’s cash budget for the months of March, April and May, and the total for the three months. On which of her monthly expenses will she likely have variances? And why?

Solutions

Expert Solution

Cash Budget

March April May
Opening balance 550 1185 2060
Salary 1800 1800 1800
Expenses
Rent -650 -650 -650
Utilities -125 -125 -125
Telephone -90 -90 -90
Food and clothing -300 -300 -300
Tax refund 240
Vacation cost -450
Ending balance 1185 2060 2245

She can have variances on the variable expenses of Utilities , Telephone, cable and internet, food and clothing. The vacation expense may also be more of less than planned. This is because they are variable expenses and depend upon the actual usage. They may change as per requirements and needs or desires.

Working


Related Solutions

Assume that when an economy has a GDP of $500, Consumption is $550. The MPC is...
Assume that when an economy has a GDP of $500, Consumption is $550. The MPC is .75. Investment is 25. Government Spending equals $50. Begin the problem by completing Income/Consumption Schedule:                                 GDP=DI       Consumption     Investment     Government                                   $500                  $550                    $25                   $50                                     600                                                      700                                     800                                     900                                   1000                                   1100 Graph the Consumption Function. Add Investment to the graph. Add Government Spending to the graph. What is the multiplier? (Use the formula discussed in your text.) What...
Assume that when an economy has a GDP of $500, Consumption is $550. The MPC is...
Assume that when an economy has a GDP of $500, Consumption is $550. The MPC is .75. Investment is 25. Government Spending equals $50. Begin the problem by completing Income/Consumption Schedule:                                 GDP=DI           Consumption                Investment                          Government                                   $500                $550                                     $25                                      $50                                     600              $550+75= 625                       $25                                      $50                                     700              $625+75= 700                       $25                                      $50                                     800              700+75= 775                          $25                                     $50                                     900              775+75= 850                          $25                                     $50                                   1000               850+75= 925                         $25                                    $50                                   1100              925+75= 1000                        $25                                   $50 Graph the Consumption...
An investment offers the following cash flows: $100 today, $550 one year from now, $550 in...
An investment offers the following cash flows: $100 today, $550 one year from now, $550 in 2 years, and $750 in 3 years. If the relevant interest rate is 8% per year (an APR, with interest compounded semiannually), what is the value of the investment 3 years from today?
1) Assume there's a security that pays a cash flow of $250 at THE BEGINNING of...
1) Assume there's a security that pays a cash flow of $250 at THE BEGINNING of each quarter for the next nine years. Interest rates are currently 6% and expected to stay there for the foreseeable future. What's the most you would pay for this security? (Be careful. Think clearly about when your payments are received, in particular your last payment). Assume it's Jan 1st, 2019. You are thinking of buying a Chick-fil-A bond that matures Dec 31st, 2031. The...
Mass Company has $ 12500 in cash on hand on January 1 and has collected the...
Mass Company has $ 12500 in cash on hand on January 1 and has collected the following budget​ data: Assume Mass has cash payments for selling and administrative expenses including salaries of $ 60000 plus commissions of 3​% of​ sales, all paid in the month of sale. The company requires a minimum cash balance of $ 10 000. Prepare a cash budget for January and February. Will Mass need to borrow cash by the end of February​? January Febuary Sales...
Sweeten Company had no jobs in progress at the beginning of March and no beginning inventories....
Sweeten Company had no jobs in progress at the beginning of March and no beginning inventories. The company has two manufacturing departments—Molding and Fabrication. It started, completed, and sold only two jobs during March—Job P and Job Q. The following additional information is available for the company as a whole and for Jobs P and Q (all data and questions relate to the month of March): Molding Fabrication Total Estimated total machine-hours used 2,500 1,500 4,000 Estimated total fixed manufacturing...
Sweeten Company had no jobs in progress at the beginning of March and no beginning inventories....
Sweeten Company had no jobs in progress at the beginning of March and no beginning inventories. The company has two manufacturing departments--Molding and Fabrication. It started, completed, and sold only two jobs during March—Job P and Job Q. The following additional information is available for the company as a whole and for Jobs P and Q (all data and questions relate to the month of March): Molding Fabrication Total Estimated total machine-hours used 2,500 1,500 4,000 Estimated total fixed manufacturing...
Sweeten Company had no jobs in progress at the beginning of March and no beginning inventories....
Sweeten Company had no jobs in progress at the beginning of March and no beginning inventories. The company has two manufacturing departments--Molding and Fabrication. It started, completed, and sold only two jobs during March—Job P and Job Q. The following additional information is available for the company as a whole and for Jobs P and Q (all data and questions relate to the month of March): Molding Fabrication Total Estimated total machine-hours used 2,500 1,500 4,000 Estimated total fixed manufacturing...
Sweeten Company had no jobs in progress at the beginning of March and no beginning inventories....
Sweeten Company had no jobs in progress at the beginning of March and no beginning inventories. The company has two manufacturing departments--Molding and Fabrication. It started, completed, and sold only two jobs during March—Job P and Job Q. The following additional information is available for the company as a whole and for Jobs P and Q (all data and questions relate to the month of March): Molding Fabrication Total Estimated total machine-hours used 2,500 1,500 4,000 Estimated total fixed manufacturing...
Sweeten Company had no jobs in progress at the beginning of March and no beginning inventories....
Sweeten Company had no jobs in progress at the beginning of March and no beginning inventories. It started only two jobs during March- Job P and Job Q. Job P was completed and sold by the end of the March and Job Q was incomplete at the end of the March. The following additional information is available for the company as a whole and for Jobs P and Q (all data and questions relate to the month of March): Estimated...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT