A family-owned auto parts store

Assignment Help Managerial Accounting
Reference no: EM13736086

Lipman Auto Parts, a family-owned auto parts store, began January with $10,300  cash. Management forecasts that collections from credit customers will be $11,400  in January and $14,800 in February. The store is scheduled to receive $5,000 cash on  a business note receivable in January. Projected cash payments include materials purchases  ($3,000 in January and $3,600 in February), direct labor ($7,000 monthly)  and manufacturing overhead ($2,500 in January and $2,800 in February). Selling  and administrative expenses are ($2,700 each month).  Lipman Auto Parts' bank requires a $10,000 minimum balance in the store's  checking account. At the end of any month when the account balance dips below  $10,000, the bank automatically extends credit to the store in multiples of $1,000.  Lipman Auto Parts borrows as little as possible and pays back loans in quarterly  installments of $2,000, plus 4% annual interest on the entire unpaid principal. The
first loan payment occurs three months after the initial loan.

Requirement
1. Prepare Lipman Auto Parts' cash budget for January and February.
2. "How much cash will Lipman Auto Parts borrow, if any, in February if collections 
from customers that month total $13,800 instead of $14,800?" Lipman Auto Parts, a family-owned auto parts store, began January with $10,300
cash. Management forecasts that collections from credit customers will be $11,400  in January and $14,800 in February. The store is scheduled to receive $5,000 cash on  a business note receivable in January. Projected cash payments include materials purchases  ($3,000 in January and $3,600 in February), direct labor ($7,000 monthly)  and manufacturing overhead ($2,500 in January and $2,800 in February). Selling  and administrative expenses are ($2,700 each month).  Lipman Auto Parts' bank requires a $10,000 minimum balance in the store's  checking account. At the end of any month when the account balance dips below  $10,000, the bank automatically extends credit to the store in multiples of $1,000.  Lipman Auto Parts borrows as little as possible and pays back loans in quarterly  installments of $2,000, plus 4% annual interest on the entire unpaid principal. The first loan payment occurs three months after the initial loan.  


Requirement
1. Prepare Lipman Auto Parts' cash budget for January and February.
2. "How much cash will Lipman Auto Parts borrow, if any, in February if collections 
from customers that month total $13,800 instead of $14,800?"

Reference no: EM13736086

Questions Cloud

Aggregate planning on tesla cars with references : A  5 page paper double spaced on Aggregate Planning on Tesla cars with references. Aggregate Planning to include Targeted Sales Forecast, Production Levels, Inventory Levels and Customers Backlog.
The company''s overall strategy : The overseas divisions, where a much higher growth potential is expected, have repeatedly complained about the time it takes to have decisions made by the staff that is headquartered in the United States. On the other hand, there have been times w..
Provide a summary statement of your message strategy : Complete the Message Strategy & Media Plan portion of the plan. Provide a summary statement of your message strategy
What are the key components of participatory democracy : What are the key components of participatory democracy? Why are the demands of the Port Huron Statement considered on the liberal/left end of the political spectrum?
A family-owned auto parts store : Lipman Auto Parts, a family-owned auto parts store, began January with $10,300  cash. Management forecasts that collections from credit customers will be $11,400  in January and $14,800 in February. The store is scheduled to receive $5,000 cash on  a..
Factors of a group work situation : Question 1: What factors of a group work situation affect cohesiveness?
Compute total payments to labor and capital : Consider and economy with the following production technology: Y = 9K^1/3 L^2/3 , where the aggregate capital stock is K=100, and aggregate labor is L=100. The price of output is 1. Compute the equilibrium wage and capital return. Compute total payme..
Search on current hiring practices and assessment tests : To assist you with this assignment, complete an internet search on the current hiring practices and assessment tests employed by Home Depot.
Extensive discussion of the wealth effect : There has been extensive discussion of the "wealth effect." The argument goes that inflated stock values were partially responsible for the strong U.S. economy of the 1990's. Explain this linkage in words and then illustrate with an Aggregate Demand/..

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Sharing of non-private demographic information

Your supervisor recently instituted a plan that encourages her managers to share non-private demographic characteristics voluntarily provided by those who purchase your firm's final product.

  Who are the stakeholders in this situation

Who are the stakeholders in this situation and what are the potential ethical issues and concerns - what suggestions can you make to reduce these concerns?

  Find the contribution margin per haircut

Find the contribution margin per haircut. Assume that the barbers compensation is a fixed cost and what will be the operating income if 20,000 haircuts are performed?

  Prepare a contribution margin income statement

Prepare a contribution margin income statement separating all variable and fixed costs into their own categories - product to manufacture and to describe the manufacturing process.

  What would be the overall margin on the order

At a break-even point of 400 units sold, variable expenses were $4,000, and fixed expenses were $2,000. What will the 401st unit sold contribute to profit?

  Coffee makers incorporated cmitwo divisions of a cmi are

coffee makers incorporated cmi.two divisions of a cmi are involved in a dispute.nbsp division a purchases part 101 and

  Create a comprehensive master budget

Create a comprehensive Master budget and a 2-3 page executive summary for The Bottled Water Company.

  Should ski pro corporation make or buy the bindings

What would be the maximum purchase price acceptable to the Ski Pro Corporation for the bindings? Support your answer with an appropriate explanation.

  Principle motives for holding cash-near cash assets

Briefly identify and explain the principle motives for holding cash and near cash assets. What are the risk-return trade-off associated with inventory management?

  A compute the break-even point in total sales dollars and

a compute the break-even point in total sales dollars and in units for 2014.b peri has proposed a plan to get the

  Breakeven cvp changes in operating income

Compute the firm's current contribution margin ratio and break-even in revenues. Recalculate contribution margin ratio and breakeven in sales if new machine is leased. What is the firm's operating income supposing that the new machine is leased?

  What is the desired roi per pair of shoes

Custom Shoes Co. has gathered the following information concerning one model of shoe:Variable manufacturing costs $50,000.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd