Prepare schedules computing inventory budgets by months

Assignment Help Financial Accounting
Reference no: EM131219363

ABC, Inc., manufactures kitchen tiles. The following information is available:

Beginning cash balance for May is $500,000

The company budgeted sales at 600,000 units per month in April, June, and July and at 450,000 units in May. The selling price is $4 per unit. All sales are cash sales. That is, customers must pay ABC, Inc. before the tiles are shipped to the customer

The inventory of finished goods on April 1 was 120,000 units. The finished goods inventory at the end of each month equals 20 percent of sales anticipated for the following month. There is no work in process.

The inventory of raw materials on April 1 was 57,000 pounds. At the end of each month, the raw materials inventory equals no less than 40 percent of production requirements for the following month.

Selling expenses are 10 percent of gross sales. Administrative expenses, which include depreciation of $2,500 per month on office furniture and fixtures, total $165,000 per month.

The manufacturing budget for tiles, based on normal production of 500,000 units per month, follows:

2387_Untitled.png

Required

1. Prepare schedules computing inventory budgets by months for:

a. Production in units for April, May, and June.

b. Raw materials purchases in pounds for April and May.

2. Prepare a Projected Operating Income Statement for May.

3. Prepare a Cash Budget for May. ABC, Inc. pays cash for all purchases.

4. Prepare a Flexible Budget for 400,000 units of sale for May.

Reference no: EM131219363

Questions Cloud

Accounting treatment for cloud computing software purchases : Using the Internet and Strayer Library, research the accounting treatment for cloud computing software purchases. Next, imagine that your company is interested in using cloud computing for all of its software purchases from a third party vendor.
Write the audit approach portion : Objective. Express the objective in terms of the facts supposedly asserted in financial records, accounts, and statements. Control. Write a brief explanation of desirable controls, missing controls, and especially the kinds of “deviations” that could..
Advanced accounting requires many rules and regulations : The latter come from many sources. In your Journal this week you will research two rules or regulations that pertain to Advanced Accounting topics and submit them to your Unit #1 Journal. What is the name of the rule or regulation? What agency or gov..
Prepare schedules computing inventory budgets by months : The company budgeted sales at 600,000 units per month in April, June, and July and at 450,000 units in May. The selling price is $4 per unit. All sales are cash sales. That is, customers must pay ABC, Inc. before the tiles are shipped to the customer..
Average price received for each issued preferred share : The shareholders’ equity section of Embrance Inc. balance sheet at December 31, 2015 is shown below. Preferred shares Authorized—200 shares Issued and outstanding—110 shares $4,290. Common shares Authorized—1,800 shares Issued and outstanding—1.200 s..
Financial assets and financial liabilities at fair value : What is the complete ASC code that provides a table that illustrates calculation of diluted EPS for the full year 20X1? What are the three valuation techniques used when measuring financial assets and financial liabilities at fair value? In the debt ..
Important role in globalization process of world economy : All of the following have played an important role in the globalization process of the world economy except ___. The conflict between owners, employees, suppliers, and customers of a company is known as ___.
Compute the company profit margin : A company reported sales of $100,000; cost of goods sold of $60,000; selling, gerneral, and administrative expenses of $15,000; and income tax expense of $10,000. Compute the company's profit margin. what is the percent?

Reviews

Write a Review

Financial Accounting Questions & Answers

  Question annie carla and betty formed the abc partnership

question annie carla and betty formed the abc partnership. they contributed the subsequent assets.annie contributed

  Prepare a cash budget with columns for each month

Prepare a cash budget with columns for each month, January through March 2003, and a fourth column for the quarterly totals

  How much cash did randys collect from its tenants

Randy's reported rent revenue for 2014 of $64,200.- How much cash did Randy's collect from its tenants during 2014?

  Find the contribution margin ratio for consumer products

Using the contribution margin approach, find the contribution margin ratio for Consumer Products if the selling price per unit is $15, the variable cost per unit is $7.50, and the fixed costs are $8,000.

  Executory costs related to leasing incude

Executory costs related to leasing incude:

  Would a merger or acquisition affect mr jones ability

Would a merger or acquisition affect Mr. Jones’ ability to change Smithon’s fiscal year-end to a calendar year-end? Could Smithon be converted to an S corporation?

  Compare the liquidity-solvency and profitability

Compare the liquidity solvency and profitability of the two companies and all of the Problems in this chapter employ decision tools

  The amount of interest payable

Several years ago, the City of Russell issued $7 million of 6 percent serial bonds at 101. Principal payments of $350,000 are due each June 30 for 20 years. The amount of interest payable (assuming an outstanding balance of $4,000,000 of bonds) that ..

  What is considered a like-kind exchange

Which activity of the tax advisor exemplifies the nature of tax compliance as a closed situation? What is considered a like-kind exchange?

  Calculate minimum annual cash savings that must be realized

Suppose that energy savings are less than claimed. Calculate the minimum annual cash savings that must be realized for the project to earn a rate equal to the firm's cost of capital.

  What amount of the proceeds from the issuance should

The market value of each detachable warrant was quoted at $25. What amount, if any, of the proceeds from the issuance should be accounted for as part of Gordon's stockholders' equity?

  Administrative expense

Identify each cost as direct materials, direct labor, factory overhead, selling expense, or administrative expense.

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