can you please show work on excel! OnWeeka) Smell Freshhand12Forecast2020PABCustomer OrdersAvailable to Promise53205030322245678Problem 6: Georgia Clay and Gravel was updating the MPS record for one of its products, Smell Fresh Cat Litter.Partially-completed MPS time-phased record is given below.203030303030Week103050204010Item: SmellFreshOnhand 12345678MPSMPS lot size=5050505050g|Forecast2020Orders520 5023322020 20 30 30 30 30 30OnWeekb) Smell Freshhand23456789ForecastCustomer OrdersPABAvailable to PromiseMPSMPS lot size=5045Projected availablebalanceAvailable-to-promiseMPSMPS Lot Size = 50.5010 30 5050 50a) Complete the MPS time-phased record (the first table on the left).The following events occurred during week 1:• Actual demand during week 1 was 25 units.• Marketing forecasted that 40 units would be needed for week 9.An order for 10 in week 2 was accepted.An order for 20 in week 4 was accepted.• An order for 6 in week 3 was accepted.• The MPS in week 1 was produced as planned.40204020501010b) Update the record below after rolling through time. Complete the second table on the left.

The given problem involves updating the MPS record for Smell Fresh Cat Litter, a product from…

Answered: On Week a) Smell Fresh hand 1 2…

Foundations of Business (MindTap Course List)

6th Edition

ISBN:9781337386920

Author:William M. Pride, Robert J. Hughes, Jack R. Kapoor

Publisher:William M. Pride, Robert J. Hughes, Jack R. Kapoor

Chapter11: Building Customer Relationships Through Effective Marketing

Section11.10A: Consumer Buying Behavior

Problem 2CC

See similar textbooks

Similar questions

Cousins Jeri Lynn De Bose, Tish Hoover, and Josephine (Joey) Parks looked forward to meeting up during the Christmas holidays to compare notes on the results of midyear teacher evaluations. All were public school teachers in districts scattered over the state. In the pressured search for new levels of teacher accountability demanded by legislators, the state department of education joined 16 other States in implementing a new teacher evaluation system. The goal is to hold teachers account-able for student learning progress in the classroom. Under the guidance of the National Council for Teacher Quality, criteria varies by State, but in most cases, 40 percent of each teacher's accountability score would be based on the principal's evaluation and ranking based on personal observation, 30 percent would be based on personal observation by a master teacher from outside the district, and the Other 30 percent would be based on student test score gains. The state department of education would set a performance goal each school district, and the principal would set a performance goal for each teacher. In preparation, the State conducted intensive training sessions for principals and designated master teachers who would conduct the evaluations based on four class observations per teacher Officials used standardized achievement tests to derive value-added scores that measure student learning over the year. Teacher ratings were 1-5, with I am being the lowest and 5 representing near perfection. The publication of the first year's evaluations stirred interest and controversy, particularly among teachers who worried about the possible long-term effects on job retention and tenure. Now, with the first-year evaluations in hand, the three cousins pored over their experiences. The three represented different types of school systems within the state. Jeri Lynn worked for a metropolitan system in the state capital. The system included many low-income students whose first language was nor English, and several schools within the system were teetering on the brink of State takeover if improvement in student scores didn't materialize this school year. Tish worked in a county System dominated by upper-income residents, and Joey taught in the rural community in which all three grew up. The rural community had high unemployment, and a low percentage of graduates went on to college. As a result, the cousins came to the table with differing teaching experiences. "The numbers are all over the place," Jeri Lynn remarked as she studied the pages. "The whole system is flawed, and they need to make changes," Joey said. "It's too subjective. The principal and master teacher observations are subjective because there are personal factors that affect a true outcome." "Yeah, look at the numbers from your upper-income district," Jeri Lynn said to Tish. "How can 60 percent of the teachers score 5s?' Tish chuckled. "Yeah, lucky us. Our schools are overflowing with children from wealthy families. These are the kids who will apply to Ivy League schools. I can tell you that the principals are going to avoid confrontation on all fronts. No principal is going to give any indication that their students are receiving an education that's less than perfect, and that means cramming the rankings with 5s. They claim a higher level of motivation for students, and thus the selection of an elite team of educators. So with those pressures, I don't think we get personal feedback that is accurate." "At the other end of the spectrum, we have my rural district," Joey said. "The big problem is that the principals know everyone and have longstanding relationships with everyone in the county, so I think scores are based on personal history. We could almost predict who would get high or low scores before the observations. For principals, it can go back as far as 'his daddy and my daddy hated each other in high school, and now I get to evaluate his daughter "I think that in many cases, principals feel pressure to align scores with state expectations. The stare expected my district to have high scores and expected rural schools such as yours to be lower," Tish said. "But isn't that partially offset by lower goals for the rural school distracts responded Joey. "The key to the accountability system is the principal in each school," Jeri Lynn suggested. "With several of the schools in Metro teetering on the edge of state takeover by the end of the year, we had lots of strict principals who wanted to hold our feet to the fire with lower scores." "I thought the whole idea was to provide the teachers With feedback so that we would know the areas where we need improvement," Tish said. "The principals were supposed to conduct two observations in the fall and two more in the spring," Jeri Lynn said. think that's asking too much of them when they already have so much on their plates. I think a lot of them are skimping on their visits. know I only had one observation last semester, and I'm sure Mr. Talley just faked the second set of numbers. The master teachers make only two observations a year, which may be more objective but counts for less." "I'm wondering, too, how a principal measure performance in a course area outside his area of expertise, such as math," Joey said. "If the guy has a phobia about math, anything the teacher says or does is going to 100k brilliant-thus a 5." Tish and Jeri Lynn looked at each other and laughed. "Maybe we picked the wrong subjects," Tish said. "My question is one of perception," Jeri Lynn said. "A large percentage of my students are ELL. That affects their scores. How do you measure a 3 in my situation against a 5 for Tish? At the end of the school year, little Carlos is thrilled that his reading in English has improved, but there`s no Big Bang here. a slow steady improvement that may not actually show up in big strides for a couple of years: "So, the question is how do they create a system that is fair?" Tish asked. "And accurate," added Jeri Lynn. How might the state control the accuracy of principals who are conducting teacher evaluations? Explain.

Recommended textbooks for you

Foundations of Business (MindTap Course List)

Marketing

ISBN:

9781337386920

Author:

William M. Pride, Robert J. Hughes, Jack R. Kapoor

Publisher:

Cengage Learning

Foundations of Business - Standalone book (MindTa…

Marketing

ISBN:

9781285193946

Author:

William M. Pride, Robert J. Hughes, Jack R. Kapoor

Publisher:

Cengage Learning

Management, Loose-Leaf Version

Management

ISBN:

9781305969308

Author:

Richard L. Daft

Publisher:

South-Western College Pub

Foundations of Business (MindTap Course List)

Marketing

ISBN:

9781337386920

Author:

William M. Pride, Robert J. Hughes, Jack R. Kapoor

Publisher:

Cengage Learning

Foundations of Business - Standalone book (MindTa…

Marketing

ISBN:

9781285193946

Author:

William M. Pride, Robert J. Hughes, Jack R. Kapoor

Publisher:

Cengage Learning

Management, Loose-Leaf Version

Management

ISBN:

9781305969308

Author:

Richard L. Daft

Publisher:

South-Western College Pub

Marketing

ISBN:

9780357033791

Author:

Pride, William M

Publisher:

South Western Educational Publishing

MARKETING 2018

Marketing

ISBN:

9780357033753

Author:

Pride

Publisher:

CENGAGE L

SEE MORE TEXTBOOKS