Question: please solve using excel and show all steps/equations. c. Determine the percentage of items in each category and the annual dollar value for each category

please solve using excel and show all

please solve using excel and show all steps/equations.

c. Determine the percentage of items in each category and the annual dollar value for each category for part b. 3. A bakery buys flour in 25 pound bags. The bakery uses 1.219 bags a year. Ordering cost is $10 per order. Annual carrying cost is 875 per bag a. Determine the economic order quantity b. What is the average number of bags on hand? C. How many orders per year will there be? d. Compute the total cost of ordering and carrying flour e. If holding costs were to increase by $9 pex year, how much would that affect the minimum total annual cost? um Sino and handline and for

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

If the X and Y coordinates (in feet) of station A are (5000.00, 5000.00), what are the coordinates of the remaining labeled corners in the accompanying figure? 430.00 ft, S 8959 E 46 41 LUI G Radius,...

please solve in excel and show all steps/equations 2. a. The following table contains figures on the monthly volume and unit costs for a random sample of 16 items from a list of 2.000 inventory items...

ignore what i put in the boxes please and please explain/show formulas especially for percent of annual dollar value!! thank you! i will like! 1 The following table contains figures on the monthly...

I need an answer for part C please The following table contains figures on the monthly volume and unit costs for a random sample of 16 items from a list of 2,000 inventory items at a health care...

The following table contains figures on the monthly volume and unit costs for a random sample of 16 items from a list of 2,000 inventory items at a health care facility Item K34 K35 K36 M10 M20 245...

just need Parts B and C please! 2. a. The following table contains figures on the monthly volume and unit costs for a random sample of 16 items from a list of 2,000 inventory items at a health care...

SHOW EQUATIONS and USE EXCEL please. 2. 1. The following table contains figures on the monthly volume and unit costs for a random sample of 16 items from a list of 2,000 inventory items at a health...

c. Determine the percentage of items in each category and the annual dollar value for each category for part b. (Enter your answers as percentages rounded to two decimal places.) ANSWER PERCENTAGE OF...

**Provide right solution and Solve all the four questions otherwise don't solve one. Provide step wise solution and Solution should be in writing. If you give wrong and incomplete solution, i will...

c. Determine the percentage of items in each category and the annual dollar value for each category for part b. (Enter your answers as percentages rounded to two decimal places.) I need the answers...

2. a. The following table contains figures on the monthly volume and unit costs for a random sample of 16 items from a list of 2,000 inventory items at a health care facility. Develop an A-B-C...

A wooden block with mass 1.75 kg is placed against a compressed spring at the bottom of a slope inclined at an angle of 28.0 (point A). When the spring is released, it projects the block up the...

Christy Enterprises reports the year-end information from 2020 as follows: Sales (100,000 units) Cost of goods sold Gross profit $500,000 300,000 200,000 Operating expenses (includes $20,000 of...

Open - form sensitivity analysis is a prescriptive data analytics technique that utilizes accounting and valuation identities to break forecast variables into smaller components that vary in...

ADVANCED ANALYSIS In the algebraic version of prospect theory, the variable X represents gains and losses. A positive value for x is a gain. a negative value for x is a lossr and a zero value for x...