For the ERPSim manufacturing game in SAP what should be the prices for 6 flavors of Museli and what should be the sales forecast and loan amount that needs to paid and what should be the amount to be paid for set up time and increasing production capacity? If possible, can you please add a template for loan and price calculator?

For the ERPSim manufacturing game in SAP what should be the prices for 6 flavors of Museli and what should be the sales forecast and loan amount that needs to paid and what should be the amount to be paid for set up time and increasing production capacity? If possible, can you please add a template for loan and price calculator?

Principles of Cost Accounting

17th Edition

ISBN:9781305087408

Author:Edward J. Vanderbeck, Maria R. Mitchell

Publisher:Edward J. Vanderbeck, Maria R. Mitchell

Chapter4: Accounting For Factory Overhead

Section: Chapter Questions

Problem 4E: Using the data in E4-2 and spreadsheet software, determine: The variable cost per unit, the total...

See similar textbooks

Similar questions

If Promus could make order amounts after realizing demand, what would the expected value of this information be? Use the simulation results to calculate the mean profit of this case to compare with the mean profit of the non-perfect information case. You will need to enter a formula for Sales.
You are creating part of an Excel model that will set the price of an item based on whether the customer is a preferred customer or not. The partially completed model in the attached file. <-- Click here to download the Excel file. In cell B6, you will enter the formula that will use this logic:When preferred status is Yes, the price is the preferred price. Otherwise the price is the regular price.= Answer ( Answer = "Yes" , Answer , Answer ) As an alternative, you could also use this logic to get the same results:When preferred status is No, the price is the regular price. Otherwise the price is the preferred price.= Answer ( Answer = "No" , Answer , Answer ) Note that these problems use short answer text boxes, and therefore can include any characters (not just numbers). Customer ID: 68YJW Prices: Regular $26.95 Customer Name Reggie Greene Preferred $21.95 Preferred? Y/N: Yes Customer Price
I need help with question 6 on how to create the customer pivot table as given. Also, can you provide the steps of how to do that in Excel? Also, please provide the steps in order to solve the problem for Finance.
Price accuracy and right product offering are important aspect of an efficient order-to-cash (OTC). How can it be achieved with a properly managed OTC? What are your suggestions? Why? (Explain in min. 3-4 sentences.)
Using the data in E4-2 and spreadsheet software, determine: The variable cost per unit, the total fixed cost, and R2. The plotted data points using the graphing function. Compare the results to your solutions in E4-2 and E4-3 and explain the reasons for the results.
Briefly explain the concept of economic, profitmaximizing pricing. It may be helpful to use graphs in your explanation.
Question 2 A seminar was recently attended by the Managing Director of XYZ Manufacturing Company Limited located at Sheffield. The focus of the seminar was "optimising scarce resources utility in a manufacturing setting with particular reference to linear programming". On his return to his base, he called for a meeting with the Management to share his experience from the seminar and the impact this will have on the decision by the Board to produce two major products in the years ahead. A group of external research experts had previously been commissioned and the following represents information from the research carried out by them The expected products are "Best" and "Smart" with expected costs statistics as follows: Best £ £ Smart (3kg@£50/kg) Material costs (5kg@£50/kg) 250 150 Labour costs Machinery time 30 (4 hours @£15/Hr) 60 (4 hours @£10/hr) 40 (2hours @£15/Hr) (5hours@£10/Hr) Other Processing Time 50 The applicable pricing policy is based on total cost of production plus 20%…
An analyst has started preparing a spreadsheet as shown below. Column A contains the headings for various parameters and Column B contains the analyst's range names to be used in Excel. A 1 Price per Unit 2 Cost per Unit 3 Profit per Unit Price_per_Unit Cost per Unit Profit$_per_Unit 4. 5 Fixed Costs 6 Variable Costs Fixed Costs VariableCosts Label each of the following range names as "Correct" if is a valid range name in Excel or "Incorrect" if the range name is not valid for use in Excel. Proposed Range Name Price_per_Unit Cost per Unit Profit$_per_Unit Fixed Costs VariableCosts
Find DL and DM Price Efficiency Volume Show me what is TO, SQ, SP, AO, AQ, AP
Please solve for duration and yield. As for yield, please make sure the final values match The completed solutions will need to be send in excel spreadsheets
URGENT! how to find the sales price per unit & Furhter Processing cost for Beta?
What is the average payment period of PETRON? NOTE: PLEASE SHOW YOUR SOLUTION AND DONT USE EXCEL