Concept explainers
1) Gertrude Products expects the following sales of its single product:
|
Units |
July |
6,000 |
August |
6,500 |
September |
7,200 |
October |
7,800 |
November |
8,800 |
Gertrude desires an ending finished goods inventory to be equal to 20% of the next month's sales needs. July 1 inventory is projected to be 1,000 units. Each unit requires 5 pounds of Chemical A and 14 pounds of Chemical B. July 1 materials inventory includes 10,600 pounds of Chemical A and 76,000 pounds of Chemical B. Gertrude desires to maintain a Chemical A inventory equal to 30% of next month's production needs and a Chemical B inventory equal to 100% of next month's production needs.
a Prepare a production budget for Gertrude for July, August and September.
a. Production |
July |
August |
September |
Qtr. Total |
Sales
|
|
|
|
|
+Ending Inv.
|
|
|
|
|
-Beginning Inv.
|
|
|
|
|
Production
|
|
|
|
|
b. Prepare a direct materials purchases budget for Chemical A, for the quarter.
b. Chemical A |
July |
August |
September |
Qtr. Total |
Production
|
|
|
|
|
x 5 Pounds
|
|
|
|
|
Chemical A needs |
|
|
|
|
+ Ending Inv.
|
|
|
|
|
Step by stepSolved in 3 steps
- pos Ibie Furniture, Inc., estimates the following number of mattress sales for the first four months of 2019: Month Sales January February 22,000 39,800 March 28,600 April 44,200 Finished goods inventory at the end of December is 6,900 units. Target ending finished goods inventory is 10% of the next month's sales. How many mattresses should be produced in the first quarter of 2019? A. 92,340 mattresses B. 68,840 mattresses TE O C. 87,920 mattresses 1 a O D. 57,760 mattresses Mi F Ju fir https: Cha The es sales 4 Missing Calculator Next http://mi tho ?3 O O O Oarrow_forwardDogarrow_forwardShadee Corporation expects to sell 560 sun shades in May and 320 in June. Each shade sells for $161. Shadee’s beginning and ending finished goods inventories for May are 80 and 55 shades, respectively. Ending finished goods inventory for June will be 55 shades. Each shade requires a total of $60.00 in direct materials that includes 4 adjustable poles that cost $10.00 each. Shadee expects to have 130 in direct materials inventory on May 1, 100 poles in inventory on May 31, and 100 poles in inventory on June 30. Required: Prepare Shadee’s May and June purchases budget for the adjustable poles. please answer with full working answer in textarrow_forward
- Lens Junction has required production of 15,400 units in January and 18,100 in February. Each lens consists of 2 pounds of silicon costing $2.50 per pound and 3 ounces of solution costing $3 per ounce. Desired inventory levels are: Jan. Feb. Mar. Beginning Inventory: Finished Goods 4,500 4,900 5,000 DM - Silicon 8,500 9,100 9,200 DM - Solution 11,200 12,000 13,000 PLEASE NOTE: Units are rounded to whole numbers with commas as needed (i.e. 1,234) - no labels. All dollar amounts are rounded to whole dollars and shown with "$" and commas as needed (i.e. $12,345), except for any "per" amounts (units or dollars), which are rounded to two decimal places and shown with "$" and commas as needed (i.e. $1,234.56) - no labels. Cost per Pound Desired Ending Inventory DM per Unit Units to be Produced Pounds Needed for Production Required DM Pounds Beginning Inventory Total Cost of DM Purchase Total DM Required Using the information above, along with the terms…arrow_forwardLens Junction sells lenses for $44 each and is estimating sales of 15,000 units in January and 19,000 in February. Each lens consists of 2 pounds of silicon costing $2.50 per pound, 3 oz of solution costing $3 per ounce, and 30 minutes of direct labor at a labor rate of $16 per hour. Desired inventory levels are: Jan. 31 Feb. 28 Mar. 31 Beginning inventory Finished goods 4,700 4,700 5,200 Direct materials: silicon 8,400 9,000 9,100 Direct materials: solution 11,300 12,100 13,100 Question Content Area Prepare a sales budget. Lens JunctionSales BudgetFor the Two Months Ending February 28, 20XX January February Expected Sales (Units) fill in the blank e3844e01cfa6fde_1 fill in the blank e3844e01cfa6fde_2 Sales Price per Unit $fill in the blank e3844e01cfa6fde_3 $fill in the blank e3844e01cfa6fde_4 Total Sales Revenue $fill in the blank e3844e01cfa6fde_5 $fill in the blank e3844e01cfa6fde_6 Total $fill in the blank e3844e01cfa6fde_7…arrow_forwardCrest Products expects the following sales of its single product Units September October November December January Required: Crest has an ending finished goods Inventory policy of 30% of the next month's sales needs. September 1 Inventory is projected to be 7,400 units. Each finished unit requires 2 units of Component X and 3 units of Component Z. August 1 materials Inventory includes 3,000 units of Component X and 159,000 units of Component Z. Crest desires to maintain a Component X Inventory equal to 10% of next month's production needs and a Component Z Inventory equal to 20% of next month's production needs. a. Prepare a production budget for Crest for the quarter ending December 31. 26,800 19,700 16,100 18,700 16,000 Crest Products Production Budget For the Quarter Ending December 31 October November Budgeted unit sales Plus: Ending finished goods inventory Less: Beginning finished goods inventory Budgeted production (units) Budgeted production (units) Direct materials…arrow_forward
- Shadee Corporation expects to sell 560 sun shades in May and 310 in June. Each shade sells for $164. Shadee's beginning and ending finished goods inventories for May are 80 and 40 shades, respectively. Ending finished goods inventory for June will be 55 shades. Each shade requires a total of $65.00 in direct materials that includes 4 adjustable poles that cost $10.00 each. Shadee expects to have 130 in direct materials inventory on May 1, 90 poles in inventory on May 31, and 110 poles in inventory on June 30. Suppose that each shade takes three direct labor hour to produce and Shadee pays its workers $14 per hour. Additionally, Shadee's fixed manufacturing overhead is $9,000 per month, and variable manufacturing overhead is $14 per unit produced. Additional information: • Selling costs are expected to be 9 percent of sales. • Fixed administrative expenses per month total $1,100. Required: Prepare Shadee's budgeted income statement for the months of May and June. Note: Do not round your…arrow_forwardShadee Corporation expects to sell 630 sun shades in May and 320 in June. Each shade sells for $162. Shadee's beginning and ending finished goods inventories for May are 60 and 50 shades, respectively. Ending finished goods inventory for June will be 55 shades. Each shade requires a total of $60.00 in direct materials that includes 4 adjustable poles that cost $5.00 each. Shadee expects to have 130 in direct materials inventory on May 1, 80 poles in inventory on May 31, and 110 poles in inventory on June 30. Suppose that each shade takes three direct labor hour to produce and Shadee pays its workers $15 per hour. Additionally, Shadee's fixed manufacturing overhead is $10,000 per month, and variable manufacturing overhead is $10 per unit produced. Use the information and solutions presented to complete the requirements. Required: 1. Determine Shadee's budgeted manufacturing cost per shade. (Note: Assume that fixed overhead per unit is $18.) 2. Prepare Shadee's budgeted cost of goods…arrow_forwardRequired information [The following information applies to the questions displayed below.] Shadee Corp. expects to sell 530 sun visors in May and 350 in June. Each visor sells for $25. Shadee’s beginning and ending finished goods inventories for May are 80 and 50 units, respectively. Ending finished goods inventory for June will be 60 units. Suppose that each visor takes 0.70 direct labor hours to produce and Shadee pays its workers $9 per hour. Required: Determine Shadee's budgeted direct labor cost for May and June.arrow_forward
- Cousin Eddy provides you with his sales forecast for the next four months: April May 750 June July 790 Sales (Units) 670 The company wants to end each month with ending finished goods Inventory equal to 40% of next month's forecasted sales. Finished goods inventory on April 1 is 268 units. Assume July's budgeted production is 700 units. In addition, each finished unit requires four pounds of raw materials and the company wants to end each month with raw materials inventory equal to 30% of next month's production needs. Beginning raw materials inventory for April was 842 pounds. Assume direct materials cost $5 per pound. Required: For May, how many units must be produced? (Hint: This is your production budget) Submit your answer below 700 with all work submitted via email.arrow_forwardHaresharrow_forwardWesley Power Tools manufactures a wide variety of tools and accessories. One of its more popular items is a cordless power handisaw. Each handisaw sells for $40. Wesley expects the following unit sales: January 2,200 February 2,500 March 2,700 April 2,500 May 2,100 Wesley’s ending finished goods inventory policy is 35 percent of the next month’s sales. Suppose each handisaw takes approximately 0.65 hour to manufacture, and Wesley pays an average labor wage of $13.50 per hour. Each handisaw requires two plastic components that Wesley purchases from a supplier at a cost of $3.00 each. The company has an ending direct materials inventory policy of 10 percent of the following month’s production requirements. Materials other than the plastic components total $4.50 per handisaw. Manufacturing overhead for this product includes $66,000 annual fixed overhead (based on production of 24,000 units) and $0.90 per unit variable manufacturing overhead. Wesley’s selling expenses are 6 percent of…arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education