Question
Jones Corporation has the following budgeted sales for the selected four-month period: Month Unit Sales July 35,000 August 20,000 September 30,000 October 25,000 Sales price
Jones Corporation has the following budgeted sales for the selected four-month period:
Month | Unit Sales |
July | 35,000 |
August | 20,000 |
September | 30,000 |
October | 25,000 |
| Sales price per unit is $200 |
| Plans are to have an inventory of finished product equal to 30% of the unit sales for the next month. There was 10,500 units in beginning inventory on July 1st. |
| Five pounds of materials are required for each unit produced. Each pound of material costs $10. Inventory levels for materials equal 20% of the production needs for the next month. |
| Desired ending inventory for September is 30,500 pounds of material. Beginning inventory for July was 25,000 pounds of material. |
| Each unit requires 2 hours of direct labor and the average wage rate is $20 per hour. |
| Variable overhead rate is $5 per direct labor hour. There is also fixed overhead of $40,000 per month. |
| The company pays a 2% commission on sales. |
| Company has fixed selling and administrative expenses as follows: Rent $10,000/month Utilities $2,000/month Advertising $500/month Office Salaries $25,500/month |
Required:
A. | Prepare a sales budget for July, August, and September and in total for the quarter. |
B. | Prepare production budgets for July, August, and September and in total for the quarter. |
C. | Prepare a direct materials purchases budget in pounds and dollars for July, August, and September and in total for the quarter. |
D. | Prepare a direct labor budget in hours and total cost for July, August and September and in total for the quarter. |
E. | Prepare an overhead budget for July, August and September and in total for the quarter. |
F. | Prepare a selling and administrative expenses budget for July, August and September and in total for the quarter. |
G. | 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.) |
H. | Prepare a cost of goods sold budget for the quarter |
I. | Prepare a budged operating income statement for the quarter- three months together |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started