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 your annual payment

You buy a TV for $1,000 on credit. You pay no money down. No payments are required for 1 year. Interest is 11%. Only annual payments are allowed.

  Investment ratios for subunits of an organization

Determine which of the following must occur before one can calculate the return on investment ratios for subunits of an organization?

  Active and passive euthanasia

Question 1.1.According to Rachels' article "Active and Passive Euthanasia", passive euthanasia is:

  What is crytons cost of capital

Dividends have grown at the rate of 4.6% per year and are expected to continue to do so for the for the foreseeable future. What is Cryton's cost of capital where the firms tax rate is 30%?

  You will receive a 100000 inheritance in 15 years your

you will receive a 100000 inheritance in 15 years. your investments earn six percent per year compounded annually. to

  Ultimate bond strength and development length

What do you understand by ultimate bond strength and development length? Explain briefly.

  Prepare the necessary adjusting entries at december 31 for

Prepare the necessary adjusting entries at December 31 for each of the above items. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.)

  Functioning in a very competitive environment

Dotcom.com is functioning in a very competitive environment. This means that other companies are trying desperately to bid lower contracts which present less margin.

  What is the stocks predicted return

what is the stock's predicted return? Round your answer to two decimal places.

  Efficient market hypothesis

There are three versions of the efficient market hypothesis: the weak form EMH, the semi-strong form EMH, and the strong-form EMH. Describe each form.

  What was the slope of the regression line

The coefficient of determination resulting from a particular regression analysis was 0.85. What was the slope of the regression line?

  What is a forecasting error why is it important to the

1.npv 1 - according to the text the npv rule states that an investment should be accepted if the npv is positive and

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