Prepare sale budget and schedule of expected cash collection

Assignment Help Finance Basics
Reference no: EM131138953

Discussion Problem: Operating Budgets

Chic Containers, Inc. manufactures CD cases. The cases sell for $10 per unit. The sales forecast predicts sales of 60,000 units for the coming year (2002), and 70,000 for the following year (2003). All sales to customers are on account. Receivables at the beginning of the year were $20,000. Chic Containers expects to collect all of the opening receivables balance and 75% of the sales made during the coming year.

At the beginning of the year, Chic Containers had 3,000 units in finished goods inventory. Desired ending inventory is 5% of the next year's projected sales.

The nylon to make these cases costs $.50 per yard, and it takes 1.5 yards to make a single case. The company began the year with 1,600 yards of nylon in raw materials inventory, and desired ending raw materials inventory is 2,000 yards. All purchases of nylon are made with cash.

Each case requires .25 direct labor hours to produce, at a rate of $10 per hour.

Variable overhead is applied using a predetermined overhead rate of $1.50 per unit. Fixed overhead for the coming year is expected to be as follows:

Depreciation $30,000
Inspector's salary $25,000
Property tax $8,000
Supervisor's salary $30,000

Variable selling and administrative expenses for the coming year are estimated at $.75 per unit sold. Fixed selling and administrative expenses are expected to be as follows:

Depreciation $10,000
Sales staff $40,000
Advertising $5,000
President's salary $45,000

Prepare the following:

1. Sales budget and schedule of expected cash collections
2. Production budget
3. Direct materials budget
4. Direct labor budget
5. Manufacturing overhead budget
6. Selling and administrative expense budget

Reference no: EM131138953

Questions Cloud

Explain why labor union leaders are strong advocates : Using market supply and demand analysis, explain why labor union leaders are strong advocates of raising the minimum wage above the equilibrium wage.
The trial balances before and after adjustment : The trial balances before and after adjustment for Garcia Company at the end of its fiscal year are presented below.
What will be your decision-making process : What will be your decision-making process? Discuss and evaluate the different techniques that could be used in capital budgeting decisions.
Production technology and production functions : Given what you know about production technology and production functions, explain this seeming inconsistency.
Prepare sale budget and schedule of expected cash collection : Prepare the sales budget and schedule of expected cash collections, production budget, direct materials budget, direct labor budget, manufacturing overhead budget and selling and administrative expense budget.
Managing assets and resources in the digital firm : Choose any business role that you are familiar with, such as Sales Manager, Customer Service Representative, Chief Financial Officer. What information is required to do the job effectively, and where does it come from? How real-time does the informat..
Selected accounts of tabor company are shown below : Selected accounts of Tabor Company are shown below.
What is the range for the relative price of cloth : What happens to those factor prices when the price of cloth rises? Who gains and who loses from this change in the price of cloth? Why? Do those changes conform to the changes described for the case with factor substitution?
Describe the evolution of hospitals and sources of law : Describe the evolution of hospitals and sources of law. Examine tort law and the criminal aspects of health care. Use technology and information resources to research issues in healthcare policy, law, and ethics.

Reviews

Write a Review

Finance Basics Questions & Answers

  What is the firm cost of debt

A firm has a weighted average cost of capital of 10.295 percent and a cost of equity of 14.7 percent. The debt-equity ratio is 0.75. Tax rate is 32%. What is the firm's cost of debt?

  Computing expected dollar value

At the end of the year, a U.S. company has expected cash flows of ¥1,000,000 from Japanese operations, CHF200,000 from Swiss operations, and €350,000 euros from German operations.

  How large should the endowment of a college be in order

How large should the endowment of a college be in order to guarantee the availability of funds for $1,000,000 per year Assume that the endowment can be invested at an annual rate of 4.5%

  Examples of major ethical breaches in the recent past

What are some examples of major ethical breaches in the recent past that have led to increased scrutiny in the field of financial reporting and analysis? Why are they important to a firm's stakeholders and the public at large?

  Should the firm accept the project if total costs consisted

Should the firm accept the project? (Hint: The project is perpetuity so you must use the formula for perpetuity to find its NPV.) If total costs consisted of a fixed cost of $10,000 per year and variable costs of $95 per unit, and if only the variabl..

  Analyzing a portfolio

You have $100,000 to invest in a portfolio containing Stock X, Y and a risk-free asset. You must invest all of your money. Your goal is to create a portfolio that has an expected return of 13.5 percent and that has only 53 percent of the risk of the ..

  Discuss the objectives of corporate governance

Discuss the objectives of corporate governance and why this has led to increased costs for publicly traded companies.

  Lily co is expected to pay a dividend of 525 on its common

lily co. is expected to pay a dividend of 5.25 on its common stock next year. the companys dividends are expected to

  Computation of value or price of bond

Computation of value or price of bond thus it makes no coupon payments over the life of the bond

  Computing wacc using before-tax yield to maturity

Before-tax yield to maturity on company’s bonds is 9%. What is the company’s weighted average cost of capital (WACC)?

  Identify the ten determinants of service quality describe

Identify the ten determinants of service quality. Describe two of them in a sentence or two each.

  Capital budgeting-computing npv

A company has developed improvements to a product line. The plant can be converted in one of two ways. Evaluate the NPV of the Type I plant bu using a 12% discount rate.

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