Calculate the unit holding costs of orders

Assignment Help Accounting Basics
Reference no: EM131971622

Assignment: Overview: Calculate Economic Order Quantity (EOQ)

Create a blank workbook and add three worksheets labeled eoq, evm and solver.

Instructions for EOQ worksheet: Build an Economic Order Quantity (EOQ) model using these variables:

Annual Demand: 105,000

Cost Per Unit: $27.38

Holding Costs: 7.5%

Ordering Costs: $273.00

Calculate the Unit Holding Costs, EOQ and the number of Orders to Place per Year.

Instructions for EVM worksheet: Build an Earned Value Management (EVM) model using these variables:

Planned Value: $45,000

Note for understanding, this based on time, and what we expected to use based on time. Your schedule variance is based on earned and planned.

Actual Cost: $39,500

Earned Value (how much has been spent based on planned costs) : $43,500

Note for understanding, this usually based on expected costs at the task level. In other words, for the tasks complete the project was expected to use this much costs. Your cost variance is based on actual and earned.

Balance at Completion: $172,000

Original Time in Months: 14

Calculate in the model:

Cost Variance

Schedule Variance

Cost Performance Index

Schedule Performance Index

Estimate at Completion

Estimated Time

Use conditional formatting to render any "bad" values red, "good" values green and "0" values yellow. Do cell by Cell.

Analyze the data and denote your evaluation of the project. Include in the evaluation comments on schedule, costs, and performance

Instructions for solver worksheet: A quilter is making table runners and placemats. It takes her 12 minutes to make a table runner and 7.5 minutes to make a placemat. Each placemat uses 1.25 yards of fabric and each table runner uses 2/3 yard of fabric.

She has 31 hours available for making the table runners and placemats and has 237 yard of fabric on hand. She makes a profit of $2.50 on each table runner and $1.75 on each placemat. How many of each item should she make in order to maximize profit?

Use the solver to answer the following questions:

How many of each product should be sold to maximize profit?

What is the maximum profit that can be achieved?

What constraint(s) caused this solution to be the best possible?

Reference no: EM131971622

Questions Cloud

Design the network requirement for advanced digital computer : You must design the network requirements for the Advanced Digital Computer Company. You will be required to develop a plan for the Company network,.
Should the two taxpayers be treated differently : If Bob takes an improper deduction for $10,000 by mistake because he misunderstood the tax law, and Jane knowingly takes a $10,000 improper deduction.
Discuss the objectives of income taxation : Objectives of Income Taxation: Let's discuss the objectives of income taxation. What do you think they are?
What is the difference between clinical registries : What is the difference between clinical registries/databases and clinical guideline/protocols?
Calculate the unit holding costs of orders : Create a blank workbook and add three worksheets labeled eoq, evm and solver.Build an Economic Order Quantity (EOQ) model using these variables.
Collection of related technologies : As you learned in this lesson, Voice over IP (VoIP) is a collection of related technologies, protocols, and techniques used to deliver voice communications
List three possible negative effects on the environment : List three possible negative effects on the environment that can result from computer use and describe one way to lessen each effect.
Write a memo about the national infrastructure protection : Write a memo about your assessment of what needs to be done to meet the standards based on the National Infrastructure Protection Plan.
Discuss the macro system response to child maltreatment : Discuss the macro system response to child maltreatment, sexual abuse, crime, and delinquency. Describe the concept of personal and interpersonal

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd