Problem - Creating a spreadsheet

Assignment Help Managerial Accounting
Reference no: EM132470050

Problem - Creating a spreadsheet

Chicago Furniture Company produces combination desk and chair sets for the elementary schools in the Midwest. As the second quarter is progressing it is important for the controller a budget for the third quarter. The sales department manager has provided the following forecast.

July 8,000 desk combos August 8,700 desk combos September 7,600 desk combos.

October 8,700 desk combos November 8,800 desk combos.

In order to ensure Just-in-Time (JIT) deliveries are maintained in accordance with the needs of the schools Chicago Furniture Company has a standing policy that the inventory at the end of each month must be equal to 40% of the following month's forecasted sales. On July 1st there will be 3,200 desk combos in inventory.

The building of each desk combo requires 12 board feet of pine planks which cost $0.70 per foot. In order to maintain proper inventory for building the desk combos the department must have 30% of the next month's production requirements.

Reference no: EM132470050

Questions Cloud

What is the company main line of business : What is the company's main line of business? Does the company follow the IASB conceptual framework to prepare its financial statements
What is the amount of Riverbeds stockholders equity : The total assets of Riverbed Co. are $900,000 and its liabilities are equal to one-fourth of its total assets. What is amount of Riverbed's stockholders' equity
Difference between inner and outer regions of adrenal gland : Explain the difference between the inner (medulla) and outer (cortex) regions of the adrenal gland.
What is accounting : Why or why not? Should Krystal accept this advice? What is accounting? What are ethics? How do accounting and ethics relate?
Problem - Creating a spreadsheet : Problem - Creating a spreadsheet. The building of each desk combo requires 12 board feet of pine planks which cost $0.70 per foot
Determine the factor type of risk ofsl level : Determine the factor Type of risk OFSL level, the factor increases or decreases risk, the type of risk (inherent and control) and provide your rational for why
What is the retained earnings amount reported on December : The balance sheet reported total assets of $54,400.00 and total stockholders' equity of $38,955.00. What is the retained earnings amount reported on December
What penalty will a tax preparer face : Walt failed to exercise due diligence. What penalty will a tax preparer face if it is determined that he failed to exercise due diligence?
What was the amount of stockholders equity at December : The owner's equity at December 31, 2011, amounted to $50,000. What was the amount of stockholders' equity at December 31, 2012

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Manage budgets and financial plans

Explain the budgeting process and its importance to a business, identifying the components of different budgets, forecast estimates for inclusion in the budgets.

  Prepare a retained earnings statement

Prepare a retained earnings statement for the year and Prepare a stockholders' equity section of given case.

  Prepare a master budget for the three-month period

Prepare a master budget for the three-month period.

  Construct the companys direct labor budget

Construct the company's direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is adjusted each quarter to match the number of hours required to produce the forecasted number of units produced.

  Evaluate the predetermined overhead rate

Evaluate the Predetermined Overhead Rate

  Determine the company''s bid

Determine the company's bid if activity-based costing is used and the bid is based upon full manufacturing cost plus 30 percent.

  Compute the pool rates for the different activities

Complete the schedule to compute the pool rates for the different activities.

  Prepare Company financial statements

Prepare Company financial statements

  Prepare an analysis of terracycles

This individual assignment is based on the TerraCycle Inc.

  Discuss the ethical issues

Discuss the ethical issues

  Political resources in emerging markets

Calculate the GDP in Income Approach  and Expenditure Approach

  Management accounting - ehsan electronics company

A new plant accountant suggested that the company may be able to assign support costs to products more accurately by using an activity based costing system that relies on a separate rate for each manufacturing activity that causes support costs.

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