Prepare a three-month cash budget

Assignment Help Accounting Basics
Reference no: EM132064612

Problem 1 - X-Ray Manufacturing has the following revenues and costs:

Sales
Fixed overhead
Direct labor
Direct materials
Selling expenses
Administrative expenses
Variable overhead
Interest expense
Income tax

$4,340,000
$1,020,000
$458,000
$620,000
$365,000
$489,000
$224,000
$118,000
$366,000

Prepare a contribution margin income statement with both dollars and percentages of sales displayed.

Problem 2 - Presented below are selected budget data items for Globe Corporation for a three-month period:


Sales
Direct materials
Direct labor
Variable overhead
Fixed overhead
Selling and admin. costs
Fixed loan payments

OCTOBER
$820,000
$123,000
$90,000
$65,600
$140,000
$312,000
$155,000

NOVEMBER
$780,000
$119,000
$85,000
$62,400
$140,000
$310,000
$155,000

DECEMBER
$850,000
$125,000
$96,000
$68,000
$140,000
$315,000
$155,000

Sales were $770,000 in August and $790,000 in September. Material usage was $115,000 in August and $118,000 in September. All sales are on account, and accounts receivable is historically collected 15% in the month of sale, 65% in the month following sales, and the remainder two months after the sale. Materials are paid for 40% in the month used and 60% the following month. All other expenses are paid in the month incurred. The cash balance was $35,000 at the beginning of October, and management wants to determine if the company will have enough cash to pay a year-end bonus.

Prepare a three-month cash budget, including a schedule for cash collections and material payments.

Problem 3 - Olympic Products Inc. manufactures and distributes barbecue grills. The company normally sells 1,000 of these grills each month for a price of $140 each. The material cost for a grill is $44 and the direct labor is $22. The variable overhead cost is $13 per grill, and the fixed overhead cost is $30,000 per month. A contract manufacturer has approached the company and offered to supply the grills ready to sell for $85 each. The company management believes that if it accepts this offer, Olympic Products will be able to lease unused factory space for $10,000 per month.

Perform a make-versus-buy analysis.

Reference no: EM132064612

Questions Cloud

Describe an action a regulatory agency took against business : Describe an action a regulatory agency took against a business in the past 6 months. Post a link to your source. Do you agree or disagree with the action?
Introduce the life of muhammad : Essay Questions: Answer the following questions. Your essays must be at least 2 paragraphs.
Describe one aspect of the classroom resources : The objective of this Assignment is to provide you with a private place to think on the page; "thinking on the page" is a phrase used to describe writing.
What was your total percentage return on this investment : You sold your stock at a price of $47.70 per share. What was your total percentage return on this investment?
Prepare a three-month cash budget : Sales were $770,000 in August and $790,000 in September. Prepare a three-month cash budget, including a schedule for cash collections
Financial ratios by themselves are of little use : A financial analyst comments: “Financial ratios by themselves are of little use. using benchmarks, illustrating your answer with potential benchmarks.
What about the notion of fraud : One evening, at a local gallery, you make an offer to purchase what you are told is an autographed print of a locally famous watercolor artist.
How much will be your payment for each month : How much will be your payment for each month? How much you end of paying after 5 years?
The important aspects of the research capstone project : Create a one-page summary of the scholarly resources you plan on using to support your conclusions in your health care management research capstone paper.

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