Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

From it we see that ABCO receives $32,000 from accounts receivable and pays out $9500 at the start fo the first week. As a matter

image text in transcribed

From it we see that ABCO receives $32,000 from accounts receivable and pays out $9500 at the start fo the first week.

As a matter of policy, ABCO maintains inventories of $2000 in parts of some obsolete models. The current balance of marketable securities is earmarked for tax payments, which are due later in the year. ABCO maintains a minimum cash balance of $500 and has an open line of credit of $7500 from a local bank. This line of credit is presently fully used, but repayment and interest payments on its loan are scheduled for later in the year. In order to preserve a favorable picture of the firm's financial situation, the manager has agreed with the local bank that ABCO's "quick ratio" should not drop below 2.0. QUESTION: What is the cash balance of ABCO at the end of week 1 and week 2? Summarize it in a "cash budget"

ABCO Manufacturing ABCO manufactures 2 products X and Y. ABCO's manager is interested in production and liquidity planning for the next 2 weeks of operation. The first week has four working days and the second week has five working days. Each working day has an eight-hour shift. The firm has 200 machines that can be used for the production of both X and Y. A unit of product X takes 10 hours of machining time, whereas a unit of Y takes 16 hours. Sales of product Y cannot exceed 800 units during the next two weeks, whereas there is no such restriction on the sales of product X. Within those limits, ABCO does not produce on inventory and sells immediately what it produces. Sales price, wages to labor; and cost of raw material per unit of product X and product Y do not vary over time and are given in the table below: Product X Product Y Sales Price $55 $125 Labor $30 $48 Raw Material $10 $50 Profit $15 $27 Wages are proportional to production volume and paid in the week when production occurs; raw materials are bought on credit of one week and delivered immediately, i.e., ABCO uses "just-in time" delivery on weekly basis and maintains no inventory of raw materials for its current products. All sales are on credit, and payments are received one week from the date of sale. The salary of the manager is $200 per week; it is not affected by the production volume, but it is paid weekly like the wages are. The balance sheet at the beginning of the planning period (BOP) is given in the table below: Assets Liabilities and Equity Cash $2000 Accounts Payable $9500 Marketable Securities $600 Bank Loans $7500 Accounts Receivable $32000 Current Liabilities $17000 Inventories $2000 Long Term Debt $22500 Current Assets $36600 Fixed Assets $50000 Net Equity $47100 Total Assets $86600 Total Liabilities and Equity $86600 ABCO Manufacturing ABCO manufactures 2 products X and Y. ABCO's manager is interested in production and liquidity planning for the next 2 weeks of operation. The first week has four working days and the second week has five working days. Each working day has an eight-hour shift. The firm has 200 machines that can be used for the production of both X and Y. A unit of product X takes 10 hours of machining time, whereas a unit of Y takes 16 hours. Sales of product Y cannot exceed 800 units during the next two weeks, whereas there is no such restriction on the sales of product X. Within those limits, ABCO does not produce on inventory and sells immediately what it produces. Sales price, wages to labor; and cost of raw material per unit of product X and product Y do not vary over time and are given in the table below: Product X Product Y Sales Price $55 $125 Labor $30 $48 Raw Material $10 $50 Profit $15 $27 Wages are proportional to production volume and paid in the week when production occurs; raw materials are bought on credit of one week and delivered immediately, i.e., ABCO uses "just-in time" delivery on weekly basis and maintains no inventory of raw materials for its current products. All sales are on credit, and payments are received one week from the date of sale. The salary of the manager is $200 per week; it is not affected by the production volume, but it is paid weekly like the wages are. The balance sheet at the beginning of the planning period (BOP) is given in the table below: Assets Liabilities and Equity Cash $2000 Accounts Payable $9500 Marketable Securities $600 Bank Loans $7500 Accounts Receivable $32000 Current Liabilities $17000 Inventories $2000 Long Term Debt $22500 Current Assets $36600 Fixed Assets $50000 Net Equity $47100 Total Assets $86600 Total Liabilities and Equity $86600

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Canadian Tax Principles

Authors: Clarence Byrd, Ida Chen

2006-2007 Edition

ISBN: 0132325314, 978-0132325318

More Books

Students also viewed these Accounting questions

Question

=+ Identify the ethical dilemma in this scenario.

Answered: 1 week ago

Question

Which companys ratios match Column D?

Answered: 1 week ago