Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please use excel and show formulas!! Jones Corporation has the following budgeted sales for the selected four- month period: Month Unit Sales July 20,000 August

image text in transcribed

image text in transcribed

Please use excel and show formulas!!

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: E. F. G. Prepare an overhead budget for July, August and September and in total for the quarter. Prepare a selling and administrative expenses budget for July, August and September and in total for the quarter. 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.) Prepare a cost of goods sold budget for the quarter Prepare a budged income statement for the quarter-the company falls into the 35% tax bracket for income taxes. H

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Microfinance

Authors: Gianfranco A. Vento, Mario La Torre

4th Edition

1403997896, 9781403997890

More Books

Students also viewed these Accounting questions

Question

=+b) Which model do you prefer? Explain briefly. Section 18.4

Answered: 1 week ago