Johnson Inc. sells high-tech staplers. Johnson is preparing budgets for the quar
ID: 2508069 • Letter: J
Question
Johnson Inc. sells high-tech staplers. Johnson is preparing budgets for the quarter ending September 30 2017. The sales price is $14.00 per stapler. Johnson expects the following number of units to be sold in the coming year July August September October 10,000 25,000 15,000 12,500 Required: Prepare a sales budget for the third quarter of the coming year, showing units and sales revenue by month and in total for the quarter Check Figure: Total projected sales revenue for the quarter-$700,000 2. Production Budget Johnson wants ending inventory to be 15 percent of the next month's budgeted sales in units. 4,000 units were on hand June 30. Required Prepare a production budget for the third quarter of the year. Show the number of staplers that should be produced cach month as well as for the quarter in total. Check Figure: Total budgeted product units to produce for the quarter-47,875 3. Three sheets of metal are required to produce a single stapler. Johnson wants to have materials on hand at the end of each month equal to 20 percent of the following month's production needs. The materials on June 30 is 8,000 sheets of metal. October production is budgeted for 15,000 units. Required: Prepare a direct materials purchases budget for metal sheets for the quarter ending September 30. Show how many sheets of metal should be purchased cach month as well as for the quarter in total. Check Figure: Total budgeted units of material to purchase for the quarter-144,625Explanation / Answer
1)
Months Units Budgeted sales
July. 10000 140000
August 25000 350000
September 15000 210000
Budgeted sales for the 3rd
Quarter 700000
2) Production budget for the third quarter of the year
July (10000 + 3750 - 4000) 9750
Aug (25000+2250- 3750) 23500
Sept (15000 +1875 - 2250) 14625
Total no of staplers to be
produced for the quarter 47875
Related Questions
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.