I need help with questions 5-8 for my accounting project.

s. ets indirect mterials (ea, sal, oil) at $0.04 per ba. Jueco es indirect labar and uilities as mised cost The variable ceempancnts are $0.45 p bag Sor indiret labe and S0.15 per bag foe utilities The fellowing fised costs per hae budeled r indiret laber, $20,000, uilities $3,000, and other, S10,000 Prepare a Manufacturing Overhead budget. 6. Varisble selling and adsinistraive espess are S1.05 per bag of ehins sold. Fixed selling and administrative expenses are $40,000 per moalth. These coss are not iemized, ie, the budeet has only two line ems-varible operting expenses and fixod operaing expenses Prepare an Opersting Espenses budget. 7. Prepare a Badgeted Manufacturing Cast per unit budget. Refer to eshibil 911 So guidnce. To calculate FMOHnit cakulate total FMOH Sr the year and divide this by buded eoduction far the year. The total grodaction volame for the year is budecled R50,00 bag Prepare a Budgeted Inceme Statement for the quarter for otu Assume inere expense of S0, and income a expense of 21 % of income before laxes 8. Direetieas Refer to Chapter 9 (The Marter Badget) for guidence in selting up your budgcts and scheduls. Adapt your schedales foe the specife detailks oatlinod in the requiremerts ve. Prepae your bulgets using Eacel. Use fermuls snd cll references so that any change you make in one bodget is carried through to all the badgets. There should be no had keyod subes in your Somu. For example, if you change the sales volume ncrease fren 6% to 7% you shoud see effects of that change thrughout the oher budts. Likewise, if the badected sellin peice changes from $1 S1200 yuu spadeet model shoald be able to quickly and casily accommedale this change, ie change the input cell for budgeted selling reice and see the effect on income The reaheet will e grded on peeseatatio, corseciness, and quality of your spcadsheet model i.c., does it update correctly foe changes in input variables). See the grding rubric on Canvs You should approach this ssignment as if you see the Mangement Aecountent at the JusOscoo Company and you are going to present these budges in a mecting to the CEO, CFO, and other management personmel Sue gescral principles to follow in corsiructin your Excel spreadsheet model: 1 Preare an iput area in waich you enter all input varibles-ea selling price budgted vulame increase, pounds per ba, ending invenory percealage, ee You may ue the "Assumpio" tab of the sample spreadsheet or a designaled area wahis your budet spcadsheet, as long as the inut seea is clearly labeled and caly ariz 2 Each schodule shoukd refer to the input area for cach constant data value (see sample spreadshoet file). To the exle possible, kecp all constant values together n one a of the worksheet An impartant principle of good specadbheet design is keep just one copy of cach constt value. That is, enler a constant value in anly ane locaticn in the worksheet. Then if you use the valne in another cell, use a l reference that refers to the costant value's unique location Example hypethetical You cntcer the constant valae of 6% for sales tax n cell ES. When you wie a fomula in your wrksheet that requires sales , eference ES in the fomula insdesd of "had codin in the 6% value Da: subtotalES Dan'tstoal6% 3 Ue cell references Sor conslant dala values and to calealate fomalas within your example, the forla to deemine curet period sales in unts should referesce ispat cell with last year's sales volume and a cell with the volume parcentage ncresse 4 Label and format appeopiately-ea, me Sto fma dollar amounts, format cells Set decimal places, cte Jusul udt Preject ACC 202-Fall 2019 Due Friday, November 15 The b Mo Company peoduces and sels ceganic plain poto chip The one pound fimily size bag of chips has two direct materials- poatoes and packaging ispreparing budgets for the seccnd quarier ending June 30, 2019 for Apeil, Mary, and Juse, and Fer each requirement below prepare badects by mon otal budaet foe the quurte 1. The previeus year's sales (2018) for the comesponn peried were 60,000 bas 70,000 ba 85,000 bag 75,000 bag 65,000 ba Apeil May June July August The company expects the above volume of sales to incresse by 6% for the period Apeil 2019-August 2019. The budgeted selling price for 2019 is $11.00 per bag of chip. The comany expects 20% of its sales to be cash (COD) sales The remaining s0% of sales will be made on credit. Prepare a Sales Budget far ot 2. The company desires to have faished goods ivenory on hand at the end of cach nth equal to 12 percent of the fellowing moth's badected un sales. On March 31, 2019, s .cxpacts to have 7,632 begs of chips on hand. Freparea Prodctiea budgst 3. The final oduct (baps of chips) sequires two diecct materiake potatoes and packaging 4 pounds of raw potatoes are required foe cach ane-pound bag of potato chips Manageme desires to have materials cn hand fie., pounds of poalo) the end of cach month equal to 25 percent of the following month's production needs The beginning maerials investory, Apeil 2019, is expected to be 66504 pounds Petaloes cost $1.10 per paund Packain material is purchasod by the roll and 50 bags of chips are peodaced from cach rell. The packaing is made fron biodegradable, organic plant ber tht extends the shelf ife of the poo chips while preserving its ehne Management desires lo hve packaging on hand at the end of cach th oqul to I5 percent of the following man's production needs The beginning iveniory of packaging (i.e alls of packaging material) in April 2019 is expected to be 200 rolls. Packaging is expected to cos $13 per rl