Crane Farm Supply Company manufactures and sells a pesticide called Snare. The following data are available for preparing budgets for Snare for the first 2 quarters of 2022. 1. Sales: quarter 1, 28,000 bags; quarter 2, 43,400 bags. Selling price is $63 per bag. Direct materials: each bag of Snare requires 4 pounds of Gumm at a cost of $4 per pound and 6 pounds of 2. Tarr at $1.50 per pound. 3. Desired inventory levels: Type of Inventory January 1 April 1 July 1 Snare (bags) 8,400 12,500 18,400 Gumm (pounds) 9,500 10,300 13,400 Tarr (pounds) 14,500 20,100 25,100 4. Direct labor: direct labor time is 15 minutes per bag at an hourly rate of $16 per hour. 5. Selling and administrative expenses are expected to be 15% of sales plus $177,000 per quarter. 6. Interest expense is $100,000. 7. Income taxes are expected to be 20% of income before income taxes. Your assistant has prepared two budgets: (1) the manufacturing overhead budget shows expected costs to be 125% of direct labor cost, and (2) the direct materials budget for Tarr shows the cost of Tarr purchases to be $300,000 in quarter 1 and $424,500 in quarter 2. (Note: Do not prepare the manufacturing overhead budget or the direct materials budget for Tarr.)

solve all of them. I mentioned in my question to solve all the parts

Elia is in the Reports tab under Business overview. She would like to open a new tab to look at other information. How can she do this? Select an answer: Left-click and then select Open Link in New Tab from the menu. Right-click and then select Open Link in New Tab from the menu. Double-click on Reports and then select Open Link in New Tab from the menu.

I really need help with this item below. I have tried a few different ways to do this problem, but the top box keeps coming back as incorrect. I know that the amounts are correct, but the first box is wrong for some reason. Please read the feedback boxes and include the appropriate formulas and cell references for this item. This is done through Excel. PLEASE HELP!!!!!! Note that the pictures are the same exact problem, but I used two separate formulas to try and solve this problem.

Typing clearly urjent

I need typing clear urjent no chatgpt use i will give 5 upvotes I need full explanation

how do you calculat mpg in excel?

Educate these stakeholders on the advantages of utilizing a spreadsheet solution and how simple it was to process data in order to generate the information provided in the report in Excel

Create a SQL table using your name with the following features: the columns of your table must include, at least the data types (in this order) and one more of your choice NOTE: You need to specify a 2 column (i.e 2 attribute 1. varchar (n), // where n covers the string length you want to enter 2. Int, 3. decimal, (precision = 8, scale = 3 4. date. 5. ??? your choice here ??? Table constraints: 1. It has a two column primary key 2. a check constraint on 2 columns, on the decimal and the date field 3. Use '2024-02-18' date as the default on the date field 5. write down your relational schema 5. Create the table, insert at least 4 rows, and do a Select * to show them example don't just copy these, change the constraint names

Hi can you show how to input in excel using the pmt formula thank you so much