Question: Please prepare an excel sheet which include ; - 12 months production of a Product P - Raw materials are A, B and C with

Please prepare an excel sheet which include;

- 12 months production of a Product P

- Raw materials are A, B and C with their prices of 10 TL, 13 TL and 8 TL

- You will use 2 unit A, 1 unit B and 4 unit C to produceproduct P

- Your monthly expences are ;

o Accountant 1000 TL

o Workers - 5000 TL (4 workers are working)

o General manager - 12000 TL

o Engineer 8000 TL

o Unexpected expences - %10 of all expences

o Rent 2500 TL

o Raw materials for 100 units each month

o Capital investment of 200.000 TL in the 1st month

o Electricity 2000 TL

o Energy 5000 TL

What should be your minimum selling price of product P ifyou can sell 100 pieces of product P every month and youhave to be in zero to zero balance at the end of 6th month?

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 Accounting Questions!

Please help with th Budgeted Absorption Costing Income Statement AutoSave Home Insert Draw Page Layout Formulas Data Review View X LG Calibri (Body) 11 A A V Paste B I U A E 5 ACH Office Update To...

Hills Corporation Please calculate the cash budget, Income statement, and balance sheet. please also show full calculation * All borrowings occur at the beginning of each month and all repayments...

Lombardi Manufacturing Ltd. Combined Cash Budget January February March Quarter Beginning Cash Balance Add Cash Collections Total Cash Available Less Cash Disbursements: Direct Material Purchases...

PLEASE I NEED HELP WITH NUMBER 10 Requirements: create a report that includes a title page and an executive summary that includes a summary of the overall master budget totals that you calculate. The...

D E G H 5 Unit selling price 63.00 The 2020 unit prices will not change for the first two quarters of 2021 8 Estimated sales in units are as follow 9 Actual 2020 Estimated 2021 10 November 9,800...

Please continue the following business plan with the following parts: ( Create a business plan about establishing an enhanced supplements manufacturing company) 3.2 The Market profile / How much of...

I need help answering questions #21 #27 #52 #54 #55 I am uploading the whole exam but only need help answering the questions I have listed above. Thank you BUS 7013 Managerial Accounting Final Exam...

Could i get help with question 43. I know the answer need to know how you get there. University of Connecticut School of Business Managerial Accounting 2101 Exam 2 Fall 15 -W November 2, 2015...

Hi could I get help with number 22, 25 41? See attached exam. University of Connecticut School of Business Managerial Accounting 2101 Exam 2 Fall 15 -W November 2, 2015 Student:...

Lombardi Manufacturing Ltd. makes medical grade face shields that are sold to hospitals and clinics across Canada. The facemasks are unique because they are a unibody design that use only one raw...

The current AUD vs. NZD spot rate is S(NZD/AUD) = 1.06. In 1 month, the spot rate can take one of two values: 1.03 and 1.09. One month interest rates are 0.5%pa in Australia and 0.6%pa in New...

On January 2, 2015, Martin Corporation acquires two properties from a shareholder in a transaction that qualifies under § 351. The shareholders basis, the fair market value, and the built-in...

Compare Gap Inc.s social audit and reporting practices with those of other companies described in this chapter. In what ways is Gaps effort different, and in what ways is it similar? Do you think...

With the BCG Matrix, growth strategies are divided into 4 quadrants True False

If the organization can offer a good quality of working life, can managers rely on that? Would that be enough to mitigate the work-related stress and trigger employee engagement in a sustainable way?

Does the work setting of the Agency (external, internal with/without the public) affect the perception of stress? Why/why not? Would it be possible to mitigate its effects in any possible way?

Do HRM managers also need to re-contextualize themselves in their role as HR managers? If so: How should they achieve semantic fit with multiple contexts in a multinational company or an...