Complete the projected financial statement analysis (pro forma 3-year financial plan) including the "questions" tab, "12 month p& l" tab, "year 1" tab, "year 2 p& l" tab, and "year 3 p& l" tab. the first year is monthly and the second and third year are presented quarterly. note the questions in the "questions" tab may be answered at different points in completing the profit and loss information. this has to be on beutymax. it is an ongoing assignment. see attachment, or provide me with a way to get you attachemnt- projected financial statement analysis to complete this part of assignment. i will provide previous assignments. i need the excel work done. you will find the attached excel doc with the 4 tabs that need to be finished.

Imagine us is a startup that offers high definition 3d prenatal ultrasounds for high-end customers. the service process includes four activities that are conducted in the sequence described below. (the time required for each activity is shown in parentheses): activity 1: welcome a patient and explain the procedure. (20 minutes)activity 2: prep the patient (e.g., show them to the room, apply ultrasound gel). (17 minutes) (*your id number represents the amount of time needed to complete this task)activity 3: take images. (5 minutes)activity 4: discuss diagnostic with patient. (20 minutes)at each location there are employees (servers) s1, s2, and s3. the assignment of tasks to servers is the following: s1 does activities 1 and 2.s2 does activity 3.s3 does activity 4.a. what is the capacity of this process (in customers per hour)? b. suppose 3 patients arrive every hour on average. ignoring any “start of day” or “end of day” effects, what are the utilizations of all three servers (%)? c. suppose each activity can be done by any server and any server can do any set of activities. however, each activity is done by only one server. for example, a possible assignment includes: s1 does activity 1, s2 does activity 2, and s3 does activities 3 and 4. of course, the original assignment of servers to activities is also feasible. what is the maximum capacity of the process (in customers per hour)? d. now consider the capacity measures in (c) and (a), what is the percentage change? why can you improve capacity without using additional resources? (there is no free lunch, right? )note: for all hw assignments, show your process of getting the results. only providing the final answers is not acceptable and will get 0%. if necessary, use a separate sheet of paper to show your work.

Ichelle is attending college and has a part-time job. once she finishes college, michelle would like to relocate to a metropolitan area. she wants to build her savings so that she will have a "nest egg" to start her off. michelle works out her budget and decides she can afford to set aside $9090 per month for savings. her bank will pay her 4 %4% per year, compounded monthly, on her savings account. what will be michelle's balance in five years?

Asupermarket has been experiencing long lines during peak periods of the day. the problem is noticeably worse on certain days of the week, and the peak periods are sometimes different according to the day of the week. there are usually enough workers on the job to open all cash registers. the problem is knowing when to call some of the workers stocking shelves up to the front to work the checkout counters. how might decision models the supermarket? what data would be needed to develop these models?