Submission Assignment 1 Assignment Details Chicago Furniture Company produces combination desk and chair sets for the...

Submission Assignment 1

Assignment Details

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 to complete 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.

Using Microsoft Excel, create a spreadsheet for the production and material purchases budget for the 3rd Quarter.

Solutions

Expert Solution

Answer is given below

for excel formulas screen shot is given at bottom

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

Suppose a friend is completing another physics assignment in their chair at their desk and you...

Suppose a friend is completing another physics assignment in their chair at their desk and you take the opportunity to turn this scenario into the physics question you now must complete. Your friend and chair have a combined constant moment of inertia of 5.5 kg m2, and the chair can freely rotate. Now your friend picks up two solid bricks (each of mass 1.7 kg) they accidentally collected from one of the campus buildings, and experiment with rotational kinematics. Supposing...

Suppose a friend is completing another physics assignment in their chair at their desk and you...

Suppose a friend is completing another physics assignment in their chair at their desk and you take the opportunity to turn this scenario into the physics question you now must complete. Your friend and chair have a combined constant moment of inertia of 4.6 kg m2, and the chair can freely rotate. Now your friend picks up two solid bricks (each of mass 1.4 kg) they accidentally collected from one of the campus buildings, and experiment with rotational kinematics. Supposing...

The company Furniture A/S produces a very well known chair which is sold all over Europe....

The company Furniture A/S produces a very well known chair which is sold all over Europe. Would it be legal for the company to set recommended sales prices that are in fact binding to its customers?

Amber Company produces iron table and chair sets. During October, Amber’s costs were as follows: Actual...

Amber Company produces iron table and chair sets. During October, Amber’s costs were as follows: Actual purchase price $ 3.20 per lb. Actual direct labor rate $ 8.40 per hour Standard purchase price $ 3.00 per lb. Standard quantity for sets produced 1,060,000 lbs. Standard direct labor hours allowed 21,000 Actual quantity purchased in October 1,365,000 lbs. Actual direct labor hours 19,000 Actual quantity used in October 1,090,000 lbs. Direct labor rate variance $6,460 F Required: 1. Calculate the total...

Amber Company produces iron table and chair sets. During October, Amber’s costs were as follows: Actual...

Amber Company produces iron table and chair sets. During October, Amber’s costs were as follows: Actual purchase price $ 1.80 per lb. Actual direct labor rate $ 7.00 per hour Standard purchase price $ 1.60 per lb. Standard quantity for sets produced 920,000 lbs. Standard direct labor hours allowed 15,000 Actual quantity purchased in October 1,065,000 lbs. Actual direct labor hours 7,000 Actual quantity used in October 950,000 lbs. Direct labor rate variance $5,000 F Required: a. Calculate the total...

Bangor Ltd is a well-established company which produces wooden garden furniture sets in its two divisions...

Bangor Ltd is a well-established company which produces wooden garden furniture sets in its two divisions A and B. Division A produces the items of furniture and then transfers them to Division B, who varnish them and sell them to a well-known national retailer for £400 per set of a table and 4 chairs. For the last number of years, the managers of the 2 divisions have communicated well and have been happy with the transfer pricing arrangements, which was...

Oficina Bonita Company manufactures office furniture. An unfinished desk is produced for $34.55 and sold for...

Oficina Bonita Company manufactures office furniture. An unfinished desk is produced for $34.55 and sold for $65.65. A finished desk can be sold for $74.00. The additional processing cost to complete the finished desk is $6.60. Prepare a differential analysis. Round your answers to two decimal places. Differential Analysis Sell Unfinished (Alternative 1) or Process Further into Finished (Alternative 2) Desks Sell Unfinished Desks (Alternative 1) Process Further into Finished Desks (Alternative 2) Differential Effects (Alternative 2) Revenues per desk...

Oficina Bonita Company manufactures office furniture. An unfinished desk is produced for $37.50 and sold for...

Oficina Bonita Company manufactures office furniture. An unfinished desk is produced for $37.50 and sold for $64.25. A finished desk can be sold for $75.00. The additional processing cost to complete the finished desk is $6.00. Prepare a differential analysis. Round your answers to two decimal places. Differential Analysis Sell Unfinished (Alternative 1) or Process Further into Finished (Alternative 2) Desks Sell Unfinished Desks (Alternative 1) Process Further into Finished Desks (Alternative 2) Differential Effects (Alternative 2) Revenues per desk...

Oficina Bonita Company manufactures office furniture. An unfinished desk is produced for $34.30 and sold for...

Oficina Bonita Company manufactures office furniture. An unfinished desk is produced for $34.30 and sold for $64.30. A finished desk can be sold for $74.00. The additional processing cost to complete the finished desk is $6.00. Prepare a differential analysis. Round your answers to two decimal places. Differential Analysis Sell Unfinished (Alternative 1) or Process Further into Finished (Alternative 2) Desks Sell Unfinished Desks (Alternative 1) Process Further into Finished Desks (Alternative 2) Differential Effects (Alternative 2) Revenues per desk...

Problem 8-08 (Part Level Submission) John’s Televisions produces television sets in three categories: portable, midsize, and...

Problem 8-08 (Part Level Submission) John’s Televisions produces television sets in three categories: portable, midsize, and flat-screen. On January 1, 2020, John adopted dollar-value LIFO and decided to use a single inventory pool. The company’s January 1 inventory consists of: Category Quantity Cost per Unit Total Cost Portable 3,600 $100 $ 360,000 Midsize 4,800 250 1,200,000 Flat-screen 1,800 400 720,000 10,200 $2,280,000 During 2020, the company had the following purchases and sales. Category Quantity Purchased Cost per Unit Quantity Sold...

Subjects