Homework 2_RFM Analysis hw Spring 2024

Consider the following linear programming problem Max. Z = 9X₁ + 16X₂ Subject to: C1: C2: C3: C4: C5: Variable Cells X₁ 2X₁ X₁ X₁ Microsoft Excel 16.0 Sensitivity Report Worksheet: [Question Sensitivity analysis.xlsx]Sheet2 Report Created: 10/24/2021 10:45:53 AM $B$5 Values x1 $C$5 Values x2 $D$10 C5Z $D$6 C1Z $D$7 C2Z $D$8 C3Z $D$9 CAZ X₂ This problem was solved using MS Solver of MS Excel. Following is the output of the solution. 3 6 3X₂ 0 0 X₂ Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease 6 3 24 9 3 Constraints Cell Name Value Price R.H. Side 05500 -5 5 15 3 0 0 0 3 24 10 0 Final Shadow Constraint Allowable Allowable Increase Decrease 1E+30 5 1E+30 24 10 6 3 3 1E+30 1E+30 7.5 3 18 1 3 1E+30 Write your report on the sensitivity analysis of constraints C2 and C3

I just need help with question 3b, unable to get the answer under Excel solver, please help.

Problem 13-3 Determining the Time Value of Money [LO13-1] Complete the following table. Use Exhibit 1-A, Exhibit 1-B, Exhibit 1-C, Exhibit 1-D. Note: Use appropriate factor(s) from the tables provided. Round time value factors to 3 decimal pla nearest whole number. Annual Deposit Rate of Number of Return Years Investment Value at the End of Time Period Total Amount of Investment $ 3,000 4 % 9 $ 3,000 8% 9 $ 3,000 4 % 18 $ 3,000 8% 18 Total Amount of Interest or Earnings

PRODUCT PK ProductID char(4) ORDER_DETAILS PK SalesOrderDetailID char(6) SALES_ORDERS PK SalesOrderNumber nvarchar(50) ProductName ProductNumber ProductLine ProductClass ProductStyle nvarchar(50) nvarchar(50) FK2 SalesOrderNum FK1 ProductID nvarchar(50) FK1 CustomerID char(5) char(4) OrderDate datetime nvarchar(2) nvarchar(2) OrderQty UnitPrice smallint DueDate datetime money ShipDate datetime nvarchar(2) Product Color ProductListPrice nvarchar(50) UnitPriceDiscount Line Total money decimal(28,6) SubTotal money TaxAmt money ProductStandardCost money Freight money TotalDue money ProductSize ProductSizeUnit MeasureCode Product Weight money nvarchar(50) nvarchar(3) Product Weight UnitMeasureCode decimal(8,2) nvarchar(3) CUSTOMER PK CustID char(5) Cust Type nvarchar(1) AddLine1 nvarchar(50) AddLine2 City nvarchar(50) nvarchar(50) PostalCode nvarchar(50) Shown above are the tables in a database with all the relevant information including the data type for each of the columns. Select ONE…

1 SSO: Texas A&M University San Antonio 110 M Question 7 - Week 13 - Homework #8 (100 points) - Connect Week 13 - Homework #8 (100 points) i ezto.mheducation.com b My Questions | bartleby Saved 7 Seminoles Corporation's fiscal year-end is December 31, 2024. The following is a partial adjusted trial balance as of December 31. Accounts Debit Retained Earnings Credit $30,000 Dividends $3,000 Service Revenue 15 points Interest Revenue 50,000 6,000 Salaries Expense 15,000 Rent Expense 6,000 Skipped Advertising Expense 3,000 Insurance Expense 11,000 Interest Expense 5,000 eBook 101 Hint Required: 1. Prepare the necessary closing entries. 2. Calculate the ending balance of Retained Earnings. Complete this question by entering your answers in the tabs below. Print Required 1 Required 2 References Mc Graw Hill Prepare the necessary closing entries. (If no entry is required for a particular transaction/event, select "No Journal Entry Required" in the first account field.) View transaction list…

Attach excel file

complete the flexible budget report (use formulas and cell referencing whenever possible in spreadsheet)

Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.

Ma1. What is true about the hotel room reservation booked by a guest through expedia.com? Select one: a. It is unwise to use such websites because they don’t help to increase hotel rooms’ revenue. b. No distribution channel fees will be paid on the revenue this reservation generates. c. It is the lowest possible cost distribution channel. d. There are fees associated with using online distribution channels such as expedia.com that hotels must pay.

8 There are ______ stages in the process of developing a sales and operations planning (S&OP) plan. a four b five c six d seven     9 The objective of ______ is to ensure that there is sufficient manufacturing and distribution capacity to meet the demand forecasts. a operations planning  b financial planning c supply planning d demand planning 10 Which planning approach is appropriate for companies that produce a combination of products and services that require similar resources? a bottom-up  b top-down c aggregate d independent

Please do not give solution in image format thanku

1. For the following problems, provide your written solutions within this template. Do not create a new file. Show all steps used in arriving at the final answers. Incomolete solutions will receive partial credit. 3. Provide formulas using Equation Editor and diagrems using Drawing Tool. 4. Use the Solver to obiain computer solutions in an Excel workbook. 5. Submit the Word and Excel workbook(s) separately as attachments. 2. Problern 1 The following network describes a transportation scenario in which there are four sources A, B, C, and D, and three destinations P, Q, and R. (The numbers next to each arrow represent the cost of transporting one unit from that particular source to the destination located at the other end of that arrow}. Sources (Supplies) Destinations (Demands) 2500 2900 4 A000 3800 8. 3800 .... **.** 9. R. at 2700 12 3700 oce D. a) Write the mathematical formulation of the problem. b} Use the Excel Solver to solve the problem. Generate the answer and sensitivity…

Please do not give solution in image format thanku In 2009, Internationale Outstanding University (IOU) had an enrollment of 27,000 undergraduates, each of whom paid $6,216 per year in tuition. In 2010, enrollment was 27,628 students, and tuition was raised 5.4%. In 2011, IOU received $186.8M in revenue from student tuition, and enrollment was 27,570 students. In 2012, it is estimated that tuition will be $7,082 and IOU needs to receive 6.5% more total revenue from tuition than in 2011.   How many students must IOU enroll to meet the 2012 revenue goal?

Comprehensive Problem 1Part 2 and Part 3: The following is a comprehensive problem which encompasses all of the elements learned in previous chapters. You can refer to the objectives for each chapter covered as a review of the concepts. Note: You must complete part 1 before completing parts 2 and 3. Part 2:  Using the attached spreadsheet, post the journal entries from part 1 to a ledger of four-column accounts. Part 3:  Prepare an unadjusted trial balance. If an amount box does not require an entry, leave it blank.

Manage Your Health, Inc. (MYH) is a Fortune 500 company that provides a variety of healthcare services across the globe. MYH has more than 20,000 full-time employees and more than 5,000 part-time employees. MYH recently updated its strategic plan; key goals include reducing internal costs, increasing cross-selling of products, and exploiting new Web-based technologies to help employees, customers, and suppliers work together to improve the development and delivery of healthcare products and services. Below are some ideas the IT department has developed for supporting these strategic goals: 1. Recreation and Wellness Intranet Project: Provide an application on the current intranet to help employees improve their health. A recent study found that MYH, Inc. pays 20 percent more than the industry average for employee healthcare premiums, primarily due to the poor health of its employees. You believe that this application will help improve employee health within one year of its rollout so…

Please Solve In 10mins I will Thumbs-up promise

Problem 15-2 Calculating Interest [LO15-3] Calculate the annual interest and the semiannual interest payment for the following corporate bond issues with a face value of $1,000. Note: Do not round intermediate calculations. Round your answers to 2 decimal places. Annual Semiannual Annual Interest Interest Interest Rate Amount Payment 3.80% 4.50% 2.45% 3.00%

Please use attached Excel format to solve if possible, I appreciate you!

Viko

- Google Chrome /mod/quiz/attempt.php?attempt=D18493758&cmid%3D845634&page%3D15 G SYSTEM (ACADEMIC) Time left 0:53:48 A local toy manufacturer is using a production line that runs 8 hours per day and produces a toy that requires a total of 7 tasks to be performed. The daily demand is 75 toys. Times of the tasks are 2.73, 2.01, 2.13, 2.0, 2.61, 2.71, and 2.95 minutes for A, B, C, D, E, F, and G, respectively. However, due to the nature of the product there are precedence rules that must be observed. Such that Task A does not need any predecessors; task B requires task A to be completed. To start task C and task D, each require task B Task C must be completed prior to stating task E. Task F needs both task D and task E to to be cor be completed. Finally, task G can start only once task F is completed. What should be the calculated cycle time in minutes? a. 6.40 O b. 4.80 Oc. None is correct O d. 6.00 O e. 5.30 om/mod/quiz/summary.php?attempt3D18493758&cmid%3845634 F2 F3 F4 F5 F6 F7 F8 F9…

Clinton Financial Consultants is a firm of chartered accountants and financial consultants. Amongst its many activities , it specializes in arranging finance for new entrepreneurs. It helps them in evaluation, preparing viable reports, documentation, legal documentation and finally obtaining a loan from banking or financial institutions. The task involves preparing a proposal, checking the background of the client firm for its creditworthiness, preparing pro forma balance sheets and profit and loss accounts for the term of the loan, carrying out a need analysis, preparing loan agreement documents and finally obtaining the loan for the client. To facilitate better management, the firm uses PERT. It is currently processing the proposed loan for Alfa enterprises. The team assigned for this project has identified the following activities: Activity Description Immediate Predecessor A Start preparing proposal as per template - B Check credit worthiness of firm - C Create a rough draft…

Job Costing Johnson Inc. is a job-order manufacturing company that uses a predetermined overhead ratebased on direct labor hours to apply overhead to individual jobs. For the current year, estimated direct laborhours are 95,000 and estimated factory overhead is $617,500. The following information is for Septemberof the current year. Job A was completed during September, and Job B was started but not finished.[LO 4-3, 4-4, 4-5]September 1, InventoriesMaterials Inventory $ 7,500Work-in-Process Inventory (All Job A) 31,200Finished Goods Inventory 67,000Material purchases 104,000Direct materials requisitionedJob A 65,000Job B 33,500Direct labor hoursJob A 4,200Job B 3,500Labor costs incurredDirect labor ($8.50/hour) 65,450Indirect labor 13,500Supervisory salaries 6,000Rental costsFactory 7,000Administrative offices 1,800Total equipment depreciation costsFactory 7,500Administrative offices 1,600Indirect materials used 12,000Required1. What is the total cost of Job A?2. What is the total…

Pls help ASAP for both

please answer within 30 minutes.

do fast

Amalia was seeking a position as a fashion designer. She’d just graduated college and hadn’t yet held a job in her field so she had no actual work samples to show an employer. However, as a requirement of her degree program, she’d completed an internship with a clothing manufacturer. She’d also volunteered at a few small fashion shows in her area. Amalia would like to create a portfolio or personal website. What items might she include? Amalia could also start a blog. Provide at least three ideas or topics for posts she might write. How do you think a portfolio, personal website and blog will improve Amalia’s chances of getting hired?

Company Name: Floward (flowers Market) Create a campaign for your company to launch, starting January 2021 till December, that will be active for 12 months. Marketing budget: SR 450,000 to spend on digital advertising media over the next 12 months. The budget also includes up to SR 340,500 for advertising creative and content development, and for the company to manage the program. What is your digital marketing campaign Schedule: recommend digital marketing content and the schedule for the content? (Must include timeline for the content distribution, frequency of posts and ads).

Comprehensive Problem 1Part 8: The following is a comprehensive problem which encompasses all of the elements learned in previous chapters. You can refer to the objectives for each chapter covered as a review of the concepts. NOTE:   You must complete parts 1, 2, 3, 4, 6 and 7 before completing part 8. Part 5 is optional. Prepare an income statement.

The second solution (3.82) is incorrect.

In order to generate a useful aggregate plan a number offeatures are required. This should include:a) A logical unit for measuring sales and output.b) A demand forecast for the intermediate planning period.c) A method to calculate the relevant costs.d) A model that combines forecasts and cost so schedulingdecisions can be made for the planning period.e) All of the above.

Please do not give image format