1. Sales Bedeet Johnson Inc. sells high-tech staplers. Johnson is preparing budg
ID: 2558811 • Letter: 1
Question
1. Sales Bedeet 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. Jonson capects 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 each month as well as for the quarter in total. Check Figure: Total budgeted product units to produce for the quarter-47,875 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 inventory 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 each month as well as for the quarter in total. Check Figure: Total budgeted units of material to purchase for the quarter-144,625Explanation / Answer
July August September Credit sales from May 10.00 June 20.00 10.00 July 70.00 20.00 10.00 August 70.00 20.00 September 70.00 Amount collected in April May June Qaurter Credit sales from Sales Amount May 0 0 0 June 150000 30000 15000 45000 July 140000 98000 28000 14000 140000 August 350000 0 245000 70000 315000 September 210000 0 0 147000 147000 Total 128000 288000 231000 647000
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.