Need finance homework help? Ask an Expert

# I would like help with a homework, similar to the following:

I would like help...

I would like help with a homework

Tutor's Assistant: Is there anything else important you think the Math Tutor should know?

Yes, I would like to make sure it's checked for plagarism I have a spreadsheet and will need to show work

Show More
Show Less
9/10/2017
Ryan, Engineer
Satisfied Customers: 9,181
Experience: B.S. in Civil Engineering
Verified
Customer reply replied 8 months ago
My solution is like the following:
Customer reply replied 8 months ago
I have an excel spreadsheet to work with
Customer reply replied 8 months ago
Company A
An electronic retail chain wishes to minimize its ordering costs for a particularly popular model of laptop computer. This retail chain has a line of credit to finance its inventory and the current interest rate is 1.5%. The chain estimates it can sell 30,000 units per year and it pays \$575 per unit. It costs \$48 to place each order. How many units should it order each time? You should round your answer up to the nearest laptop unit. You must show your work.
Company B
A manufacturer of laptop computers operates a plant with an annual capacity of 6,630,000 laptop units. One of its models is expected to sell 390,000 units in the coming year. How large should each product lot be if it costs \$575 to change production from one model to another. Assume that the manufacturer values each laptop unit at \$280 and it has a holding interest rate of 2%. You should round your answer up to the nearest laptop unit. You must show your work.

Hi,

You mentioned that you have an Excel spreadsheet for this. Can you attach a copy of that spreadsheet so I can see the format that you are supposed to follow?

Thanks,

Ryan

Customer reply replied 8 months ago
Notes...To work part B step by step to get the order of operations right rather than trying to work it all at once find:
• D/P (if both given in same time frame - annual, etc)
• 1-D/P
• Ch (from rate * unit price)
• Denominator which would be Ch*(1-D/P)
• Numerator which would be 2*D*Cs
• Numerator/Denominator
• Sqrt(Numerator/Denominator)
• Roundup(Sqrt(Numerator/Denominator))

Hi again,

Please see the attached Excel file for the worked out solution:

OrderQuantity

You can copy and paste the information from this Excel file into the provided template.

Thanks,

Ryan

Customer reply replied 8 months ago
Hello Ryan,Thank you for your response . I apologize for the delay. I still need to show work , outlining how I arrive to the calculations.

Ok, I'll see what I can add to it. Excel is kind of a horrible platform for "showing work", but I'll do what I can.

Customer reply replied 8 months ago
Okay.thanks! You can type out your steps in the cells or you can use a word document and attach or take a screen image and put in the file.
Customer reply replied 8 months ago
There are 2 other parts to this course. Would you like me to send separately or attach as a document?

How about if I send a Word document that shows the work then?

Hi again,

Please take a look at the Word document at the following link and let me know if that meets your needs for this project.

Quantities

Regarding the other parts for your course, you should post those in a new question since they are a separate assignment. If I was unable to help with those for any reason, having them posted here in this thread would make it more difficult for you to get help from another expert.

If there is anything else that I can do to help, please don't hesitate to ask.

Regards,

Ryan

Customer reply replied 8 months ago
okay..thank you so much!

You're quite welcome.

I looked at the other assignment. Yes, I can help you with that one.

Please be sure to rate the service that you received for the original task, and open a new question page for this new task. When you open the new page, be sure to put "For Ryan Only" at the beginning so that your request will be clear. Feel free to ignore responses from anybody who fails to honor your request, if you so choose.

Thanks,

Ryan

Ryan, Engineer
Satisfied Customers: 9,181
Experience: B.S. in Civil Engineering
Verified

Hi again,

Try this version:

Quantities2

Thanks,

Ryan

Customer reply replied 8 months ago
I will. The excel has a 75% match as well.

Not sure we can do much about that. You were given fairly direct instructions about breaking down the calculation into steps. I would expect that pretty much the entire class will have similar looking Excel sheets.

Customer reply replied 8 months ago
Okay. Just want to make sure. I submitted a work solution before in excel for this same class and they rejected it due to matching similarities.
Customer reply replied 8 months ago
Did you get the file for the other solutions. I submitted a request on Sunday for that portion

You might change the wording of some of the labels for the quantities in the Excel sheet.

No, I didn't receive any files for that. How did you send them?

Customer reply replied 8 months ago
Okay...thanks
Customer reply replied 8 months ago
I've attached another copy.Thanks!

Ok, got it. I'll post the response in the other thread.

Ryan, Engineer
Satisfied Customers: 9,181
9,181 Satisfied Customers
Experience: B.S. in Civil Engineering

Ryan is online now

A new question is answered every 9 seconds

• Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
• Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

## What Customers are Saying:

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

He answered my question promptly and gave me accurate, detailed information. If all of your experts are half as good, you have a great thing going here.

DianeDallas, TX

< Previous | Next >

## Meet the Experts:

linda_us

Master's Degree

852 satisfied customers

A tutor for Business, Finance, Accounts and other related topics.

F. Naz

Bachelor's Degree

540 satisfied customers

Have completed B.COM and CA Finalist

Bizhelp

Accountant

260 satisfied customers

BA degree and Certified Public Accountant

214 satisfied customers

dasdasd

Mr. Gregory White

Master's Degree

211 satisfied customers

M.A., M.S. Education / Educational Administration

Brittany

Professional

30 satisfied customers

Dimitry K., Esq.

Doctoral Degree

19 satisfied customers

< Previous | Next >

Related Business and Finance Homework Questions
Can you explain me the answer for the conventional cash
can you explain me the answer for the conventional cash flows … read more
Expert
214 satisfied customers
A five-year prospective cohort study has just been
A five-year prospective cohort study has just been completed. The study was designed to assess the association between supplemental vitamin A exposure and mortality and morbidity for measles. The RR f… read more
Sandhya_sharma
Master\u0027s Degree
559 satisfied customers
I need help with the j&l accounting graded project. It is
good dayI need help with the j&l accounting graded project. It is due soon. please get back to me soon… read more
PDtax
Owner
Master\u0027s Degree
1 satisfied customers
On Black Friday 2014, Amazon.com featured a Panasonic 3D
On Black Friday 2014, Amazon.com featured a Panasonic 3D Blu-ray Player for \$60 normally selling for \$72. Calculate the dollar markdown and the markdown percent based on the selling price to the neare… read more
Expert
214 satisfied customers
Mr. has recently died. He was donor/custodian of his
Mr. Thomas has recently died. He was donor/custodian of his grandson's UTMA account. Is the custodial account value included in Mr. Thomas' gross estate and why or why not?… read more
Dr Arthur Rubin
Doctoral Degree
24 satisfied customers
Elenore recently inherited 4,000 shares of stock from her
Elenore recently inherited 4,000 shares of stock from her deceased husbands estate. During his lifetime, Elenore's husband had purchased these shares for \$5 a share. The value of the stock had increas… read more
Dr Arthur Rubin
Doctoral Degree
24 satisfied customers
The intent of this case study is to gauge your thought
The intent of this case study is to gauge your thought process, creativity, ability to analyze data, and approach to process control and improvement. You should plan to review the prompt below and pre… read more
F. Naz
Bachelor's Degree
CA Finalist & Completed B.com
540 satisfied customers
I have a question here about NPV, IRR. Explain how and why
Explain how and why the length of time and dollar value of a project impacts whether NPV or IRR has greater or lesser influence on project decision-making. … read more
F. Naz
Bachelor's Degree
CA Finalist & Completed B.com
540 satisfied customers
Age 63) established a trust and named his wife, Camile (age
James (age 63) established a trust and named his wife, Camile (age 40) an income beneficiary for 20 years. After 20 years John's son Bill (age 30) and nephew , Bob, (age 22) are to receive lifetime in… read more
Master's Degree
180 satisfied customers
Was given a house last year by his father,. At the date of
James was given a house last year by his father, Michael. At the date of the gift the fair market value of \$175,000, and its adjusted basis to the donor (his father, Michael) was \$105,000. The donor p… read more
PDtax
Owner
Master\u0027s Degree
1 satisfied customers
I have a set of 6 questions for public economics i'm a
Hi I have a set of 6 questions for public economics i'm a senior at NYU … read more
F. Naz
Bachelor's Degree
CA Finalist & Completed B.com
540 satisfied customers
I need help with this. It is in Marketing but I do not see
I need help with this. It is in Marketing but I do not see this in the Category below. This is due by May 12, 2018… read more
F. Naz
Bachelor's Degree
CA Finalist & Completed B.com
540 satisfied customers
My daughter wants to learn violin and I gave her my
Hello. My daughter wants to learn violin and I gave her my late father's violin, bought in the early 40s. The label inside says J.P. Vuillaume Paris 1850 … read more
Judith-on-Antiques
Appraiser, Author, TV Personality
Bachelor\u0027s Degree
4,325 satisfied customers
Ken, aged 42, works at the local take-away shop in his home
Ken, aged 42, works at the local take-away shop in his home town of Daintree. Ken is living at home with his parents in Daintree in Queensland. He wants to start saving for his future so he purchases … read more
Zhannaxena
42 satisfied customers
Emporia Corporation is a lessee with a capital lease. The asset
Emporia Corporation is a lessee with a capital lease. The asset is recorded at \$630,000 and has an economic life of 8 years. The lease term is 5 years. The asset is expected to have a fair value of \$2… read more
LEV
Retired
Bachelor's Degree
14,896 satisfied customers
Considering a purchase or lease of a vehicle for 100% business use and looking at a SUV over 6,000 GVWR, and holding for 5 years. What would my depreciation deduction be for each year based on taking … read more
PDtax
Owner
Master\u0027s Degree
1 satisfied customers
How might a physician specializing in geriatrics also benefit
How might a physician specializing in geriatrics also benefit from a capitated program? What might they use as their median and revenue criterion?… read more
BMW
Post-Doctoral Degree
1 satisfied customers
Marketing and RFPs
I have owned a business called Functional Rehab for 20 years. We do work for auto insurance no fault insurance in Ontario. For the first 10 years I did case management and then later developed the bus… read more
Family Physician
Doctoral Degree
140 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less