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

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

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