I took a picture of what i have so far, I am having trouble with the direct material budget. 3. The jackets require two direct materials: silk fabric and viscose fabric for lining.SilkSilk fabric is purchased by the yard. 1.75 yards of silk fabric are required for eachjacket produced. Management desires to have materials on hand at the end of eachmonth equal to 15 percent of the following month's jacket production needs. Use the@ROUND function to round to the nearest whole number the number of yards1of silk desired in ending inventory. The beginning inventory of silk fabric, July2023, is expected to be 220 yards. Silk fabric is expected to cost $25.00 per yard. Usethe @ROUND function to round to the nearest whole number the number ofyards of silk to purchase (DM to purchase). (NOTE: budgeted production inOctober is required in order to complete the direct materials budget for September.)Viscose for liningViscose fabric is purchased by the roll of 10 yards. 2.2 yards of viscose fabric arerequired for each jacket produced. Management desires to have viscose fabric onhand at the end of each month equal to 11 percent of the following month'sproduction needs. Use the @ROUND function to round to the nearest wholenumber the number of viscose yards desired in ending inventory. The beginninginventory, July 2023, is expected to be 187 yards. The roll of 10 yards is expected tocost $110. Use the @ROUND function to round to the nearest whole number thenumber of viscose fabric yards to purchase (DM to purchase). (NOTE: budgetedproduction in October is required to complete the direct materials budget forSeptember.)Prepare a Direct Materials budget. Also, because two direct materials are requiredfor production - silk and viscose fabric - you will need a separate schedule foreach direct material. Sales BudgetUnit SalesUnit PriceSales RevenueCash SaleCredit SaleTotalProduction Budget0.12TotalDirect Material BudgetTotalDirect Labor Budget$$0.10 $0.901.15 $5801.15 $667.00 $66.70 $600.30667.00 $July83667.00750JulyJulyJuly6001.15 $690.00 $69.00 $621.00690.00 $August90690.00780AugustAugustAugust6501.15 $747.50 $74.75 $672.75747.50 $September117747.50865SeptemberSeptemberSeptember8501.15977.5097.75 $879.75977.50 $October138977.501,116OctoberOctober$$October1,0001.151,150.00115.001,035.001,150.00November1,150.001,150NovemberNovember0November0O

A direct materials budget is one of the budget which a company prepares so that the materials which are required can be purchased for each month or for a period as per basis of the requirements set by the company.Production Budget for Silk FabricJulyAugustSeptemberOctoberNovemberBeginning Inventory220157.5170.625223.125262.5Yards as per Sales101510501137.51487.51750Ending Inventory157.5170.625223.125262.50Total Yards Required9531063119015271488Rate Per Yard $ 25 $ 25 $ 25 $ 25 $ 25Total Cost for Silk Fabric $ 23,825 $ 26,575 $ 29,750 $ 38,175 $ 37,200Production Budget for Viscose FabricJulyAugustSeptemberOctoberNovemberBeginning Inventory187145.2157.3205.7242Yards as per Sales12761320143018702200Ending Inventory145.2157.3205.72420Total Yards Required12341332147819061958Roll is Purchased in 10 Yards1010101010Number of Rolls Required124134148191196Rate per roll $ 110 $ 110 $ 110 $ 110 $ 110Total Cost for Viscose Fabric $ 13,640 $ 14,740 $ 16,280 $ 21,010 $ 21,560Production BudgetJulyAugustSeptemberCost of Raw Materials $ 37,465 $ 41,315 $ 46,030

Answered: Prepare a Direct Materials budget.…

Business

Accounting

Prepare a Direct Materials budget. Also, because two direct materials are required for production - silk and viscose fabric - you will need a separate schedule for each direct material.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

1. A budget is a detailed financial plan that quantifies future expectations and actions relative to acquiring and using resources. a. True b. False 2. Budgets should not be used to provide managers with “pre-approval” for the execution of spending plans. a. True b. False 3. A flexible budget is not designed to change with changes in activity level. a. True b. False 4. The production budget comes before the materials purchases budget. a.True b. False 5. The starting point for the master budget is an assessment of anticipated production next year. a. False b. True
Suppose for a moment that you are a production manager in a manufacturing company and you just received a poor performance rating for not meeting your budget. If you were slightly over budget, identify at least two possible reasons for the budget variance. Please provide specific examples.
45. Using the flexible (as opposed to a static) budget is unlikely for which of the following? Group of answer choices a. Costs of the product distribution department. b. Costs of the manufacturing department. c. Costs of the general finance department. d. Costs of the material receiving department.
Hi, I ahve just signed up and i need to get the asnwer to this assignment. Is this possible?
When developing a budget we focus first on sales. Why do be begin with sales? What are some of the factors we should consider when preparing the sales budget?
In the proper budget equation,income can someone be less than your combined expenses and saving. True or false
Read the attached article on Zero Based Budgeting at Shell and answer the following questions: 1. The article refers to a “substantial impact” on the company’s cost budget; how significant was the expected reduction? 2. What aspects of the business were “off limits” during this exercise? 3. Describe what YOU think “cost creep” means and how it may arise? 4. How was the program first established? 5. Did the exercise require a lot of resources? 6. What three fundamental questions were asked? 7. The results of the analysis were presented to the company’s leadership. What happened next? 8. The article refers to a “three-step implementation.” What were the three steps? 9. Briefly describe what they assumed to be the “must-have” activity? 10. What categories of “nice to have” activities resulted? 11. What items made their decisions more tough? 12. The article talks about rebalancing the work that is managed in-house and work that is contracted out; provide examples of activities that were…
How does a schedule of collections from sales assist in preparing the cash budget? How are standards used in budgetary performance evaluation? The materials cost variance report for Nickols Inc. indicates a large favorable materials price variance and a significant unfavorable materials quantity variance. What might have caused these offsetting variances?
How do managers use budgets to control business activities?a) Match the concept (by number) to the correct terminology. 1. Static Budget2. Budget Performance Report3. Variance4. Static Budget Variance5. Flexible Budget6. Flexible Budget Variance7. Sales Volume Variance______ A budget prepared for various levels of sales volume.______ The difference between actual results and the expected results in the flexible budget for the actual units sold. ______ The difference between the expected results in the flexible budget for the actual units soldand the static budget. _____ The difference between actual results and the expected results in the static budget. _____ A report that summarizes the actual results, budgeted amounts, and the differences. _____ A budget prepared for only one level of sales volume. _____ The difference between an actual amount and the budgeted amount; labeled as favorable if it increases operating income and unfavorable if it decreases operating income. In…
These are True/False questions. ____ 6. If the total unit cost of manufacturing Product Y is currently $36 and the total unit cost after modifying the style is estimated to be $48, the differential cost for this situation is $12. ____ 7. A process whereby the effect of fluctuations in level of activity is built into the budgeting system is referred to as flexible budgeting. ____ 8. In an investment center, the manager has the responsibility and the authority to make decisions that affect not only costs and revenues, but also the plant assets invested in the center. ____ 9. The capital expenditures budget summarizes future plans for acquisition of fixed assets. ____ 10. The process by which management plans, evaluates, and controls long-term investment decisions involving fixed assets is called capital investment analysis.
Which of the folllowing statements is true: a. One of the weaknesses of budgets is that they are of little value in uncovering potential bottlenecks. b. In a production budget, if the number of units in finished goods inventory at the end of the period is less than the number of units in finished goods inventory at the beginning of the period, then the expected number of units sold is less than the number of units to be produced during the period. c. A benefit from budgeting is that it forces managers to think about and plan for the future. d. The selling and administrative expense budget lists all costs of production other than direct materials and direct labor. e. The disbursements section of a cash budget consists of all cash payments for the period except cash payments for dividends. O Statement d. O Statement c. Statement b. O Statement e. O Statement a.
i don't understand the cash budget can you do it again?