Prepare an ending finished goods inventory budget

Assignment Help Accounting Basics
Reference no: EM132028199

Problem - Jones Corporation has the following budgeted sales for the selected four-month period:

Month - Unit Sales

July - 20,000

August - 35,000

September - 25,000

October - 30,000

Sales price per unit is - $180

Plans are to have an inventory of finished product equal to 20% of the unit sales for the next month. There was 4,000 units in beginning inventory on July 1st.

Three pounds of materials are required for each unit produced. Each pound of material costs $20. Inventory levels for materials equal 30% of the needs for the next month.

Desired ending inventory for September is 25,200 pounds of material. Beginning inventory for July was 20,700 pounds of material.

Each unit requires 0.6 hours of direct labor and the average wage rate is $16 per hour.

Variable overhead rate is $3.50 per direct labor hour. There is also fixed overhead of $22,000 per month.

The company pays a 3% commission on sales.

Company has fixed selling and administrative expenses as follows:

Rent $6,000/month

Utilities $1,200/month

Advertising $400/month

Office Salaries $35,000/month

Required:

A. Prepare a sales budget for July, August, and September and in total for the quarter.

B. Prepare production budgets for July, August, and September and in total for the quarter.

C. Prepare a direct materials purchases budget in pounds and dollars for July, August, and September and in total for the quarter.

D. Prepare a direct labor budget in hours and total cost for July, August and September and in total for the quarter.

E. Prepare an overhead budget for July, August and September and in total for the quarter.

F. Prepare a selling and administrative expenses budget for July, August and September and in total for the quarter.

G. Prepare an ending finished goods inventory budget for the quarter (Hint: You have already calculated the desired ending finished goods inventory amount. Assume a stable per unit rate and round the per unit fixed factory overhead rate to two decimal places.)

H. Prepare a cost of goods sold budget for the quarter

I. Prepare a budged income statement for the quarter-the company falls into the 35% tax bracket for income taxes.

Reference no: EM132028199

Questions Cloud

Calculate the firm weighted average cost : Firm now has financed 33 percent of its assets using debt and 57 percent using equity. Calculate the firm's weighted average cost of capital
How many shares can be purchased in lieu of making : If the firm can repurchase stock at $62.00 per share, how many shares can be purchased in lieu of making the proposed cash dividend payment?
What is super tea company expected dividend stream : What is Super Tea company expected dividend stream over the next three years?
Would you be able to live on your social security alone : As part of your planning, how can you estimate what you can expect from Social Security as a contribution to your retirement income?
Prepare an ending finished goods inventory budget : Prepare an ending finished goods inventory budget for the quarter (Hint: You have already calculated the desired ending finished goods inventory amount
What is the cost of equity from retained earnings : Assume that Kish Inc. hired you as a consultant to help estimate its cost of capital. You have obtained the following data: D0 = $0.90; P0 = $47.50.
Annualized rate of return on investment : Compute (a) the annualized rate of return on this investment if you had paid cash, and (b) your rate of return with the margin price.
How large a fund will you need : How large a fund will you need when you retire in 24years to provide the 25-year, $20, 000 retirement annuity? How much will you need today as a single amount.
Identify and analyse the ethical issue and risks : Assignment on Ethics and Sustainability - Choose an organisation that has recently been in the media regarding an ethical issue

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

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