Question: PLEASE COMPLETE IN EXCEL AND PROVIDE FORMULAS SO THAT I CAN ANSWER THE REST OF MY QUESTIONS. THANK YOU A bakery buys flour in 25-pound

PLEASE COMPLETE IN EXCEL AND PROVIDE FORMULAS SO THAT I CAN ANSWER THE REST OF MY QUESTIONS. THANK YOU

A bakery buys flour in 25-pound bags. The bakery uses 1,900 bags a year. Ordering cost is $9.95 per order. Annual carrying cost is $72.95 per bag. a. Determine the economic order quantity. b. What is the average number of bags on hand? 1 2 4 c. How many orders per year will there be? 3 . 1 d. Compute the total cost of ordering and carrying flour. 3 4 5 5 7 e. If holding costs were to increase by $5.95 per year, how much would that affect the minimum total annual cost? 1 2 3 4 6 *Round your final answers to zero decimal places for questions a-c. 7 *Round your final answers to two decimal places for questions d&e

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!

I need help with he Foundational 15 (1-15), please respond with the answers in excel and with formulas. Please let me know if you have any questions. Thank you REVIEW PROBLEM: COMPARISON OF CAPITAL...

CAN I ASK HELP WITH THIS? Directions. This activity will check if you really understand how to use different formulas of EOQ and ROP in every situation. Write your answers on the answer sheet...

Note: Please provide detailed steps (intermediate formula and final result) for each answer. Late homework will receive NO credits. If you have any difficulties, please make an appointment with me. ....

harsh A bakery buys flour in 25-pound bags. The bakery uses 1,215 bags a year. Ordering cost is $10 per order. Annual carrying cost is $75 per bag. What is the annual flour carrying cost? NEED...

Q3 MGMT Please, provide the answer to the questions asked. not only the equations and the anwers. 3. A large bakery buys flour in 25-pound bags. The bakery uses an average of 1,215 bags a year....

1) A bakery buys flour in 25kg bags. This bakerys annual demand for flour is 4,860 such bags. Ordering and receiving costs $10 per order and shipment, holding costs is $75/bag/year. Answer the...

This SQL project in three Phases and the instruction as below: Instructions Follow the steps and let me know if you have any questions. The intent of the project is to create a project you can use in...

i just need to know how to do the excel sheets with formulas please. sorry for all of the pictures! im not positive whats important! thank you! this is everything i know Frenchies: Creating and using...

BIZ3189 Management Information Systems Take-home Exam 1 The tasks in this exam aim at developing a basic level of understanding on Excel and how you can use it to develop Decision Support Systems....

Using the link attach create a master budget. This assignment is to be submitted using an Excel XLS or XLSX workbook. Each budget schedule is to be contained on a separate spreadsheet tab. You are to...

Analyze the composition of two of the groups to which you belong. How are they similar in composition how do they differ?

Coral Rose is the owner of Rose Thai Restaurant. At the beginning of the year, she predicted the annual operating income to be $360,000. By the end of the year, she calculated the flexible budget for...

Which of the following examples may lead directly to a favorable fuxed overhead volume variance? A . A decrease in county property taxes for the factory B . A decrease in wages paid to factory...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...