Mr/Ms

please show me how to do question No 27. by the way , please show me how to get the budget rate (. i dont know the labor hours and machines hours. , where to get the number; and i also didnt find those number in the question hint )

please dont post other one's work , i want yo understand it instead of only the answers

thank you

6-27 Budgeting: direct material usage, manufacturing cost, and gross margin. Xander Manufacturing pary target anventory is 14.000 wheels and beginning invent 2 Compute the number of bicycles that Yucatan should produce What actions can Yucatan managers take to reduce budgeted purchasing costs of wheels assum Compute the budgeted purchases of when it and in pasos 626 Revenues and production budget Saphire, Inc, borties and distributes mineral water from the company's natural springs in northern Oregor Saphire markets two products: 12-ounce disposable 1. For 2018, Saphire marketing managers project monthly sales of 500,000 12-ounce bottles and 130,000 T-gallon containers. Average selling prices are estimated at $0,30 per 12-ounce bort and $1.60 per 1-gallon container. Prepare a revenues budget for Saphire, Inc., for the year ending 2 Saphire begins 2018 with 980,000 12-ounce bottles in inventory. The vice president of operations to- quests that 12-ounce bottles ending inventory on December 31, 2018, be no less than 660,000 bottes Based on sales projections as budgeted previously, what is the minimum number of 12-ounce bottles 2 The VP of operations requests that ending Inventory of 1-gallon containers on December 31, 2018, bo 300,000 units. If the production budget calls for Saphire to produce 1,200,000 1-gallon containers during Yucatan usailits wheel needs for extra wheels for replacement parts are order purchase price is 400 pesos per wheel Queired 1. Compute the budgeted revenues in pesos the same budgeted sales for Model XG? bomer and 1-gallonsable plastic containers d December 31, Saphire must produce during 2018? 2018, what is the beginning inventory of 1-gallon containers on January 1, 2018? Company manufactures blue rugs, using wool and dye as direct materials. One rug is budgeted to use 38 skoins of wool at a cost of $2 per skein and 0.8 gallons of dye at a cost of S6 per gallon. All other materis als are indirect . At the beginning of the year Xander has an chventory of 458,000 skeins of wool at a cost of S961,800 and 4,000 gallons of dye at a cost of $23,680. Target ending inventory of wool and dye is zero. Xander uses the FIFO inventory cost-flow method. Xander blue rugs are very popular and demand is high, but because of capacity constraints the firm will produce only 200,000 blue rugs per year The budgeted selling price is $2,000 each. There are no rugs in beginning inventory: Target ending inventory of rugs is also zero Xander makes rugs by hand, but uses a machine to dye the wool. Thus, overhead costs are accumu- lated in two cost pools-one for weaving and the other for dyeing. Weaving overhead is allocated to prod- ucts based on direct manufacturing labor-hours (DMLH). Dyeing overhead is allocated to products based on machine-hours (MHL There is no direct manufacturing labor cost for dyeing Xander budgets 62 direct manufacturing labor- hours to weave a rug at a budgeted rate of $13 per hour. It budgets 0.2 machine-hours to dye each skein in the dyeing process [ K Delete L End 20 ? + Shift Alt Fn MO Ctrl ASSIGNE 0 The following table presents the budgeted overhead costs for the dyeing and weaving cost pools Dyoing (based on 1,400,000 MH) Weaving (based on 12,400,000 DMLH) Variable costs Indirect materials $15,400,000 Maintenance 6,560,000 5,540,000 Utilities 7,550,000 2,890,000 Fixed costs Indirect labor 347,000 1,700,000 Depreciation 2,100,000 274,000 Other 723,000 5,816,000 Total budgeted costs $17,280,000 $31,620,000 1. Prepare a direct materials usage budget in both units and dollars. 2 Calculate the budgeted overhead allocation rates for weaving and dyeing. 3. Calculate the budgeted unit cost of a blue rug for the year. 4. Prepare a revenues budget for blue rugs for the year, assuming Xander sells (a) 200,000 or (b) 185,000 blue rugs (that is, at two different sales levels). 5. Calculate the budgeted cost of goods sold for blue rugs under each sales assumption. Find the budgeted gross margin for blue rugs under each sales assumption. What actions might you take as a manager to improve profitability if sales drop to 185,000 blue rugs? How might top management at Xander use the budget developed in requirements 1-6 to better manage the company? Company provides gutter cleaning services to residential arenting cam