Jack and Jill operate a small soft serve ice cream shop every summer in York, Me
ID: 453496 • Letter: J
Question
Jack and Jill operate a small soft serve ice cream shop every summer in York, Me. As they plan for the upcoming summer, they need to borrow operating cash from the local bank. They borrow all that they need early in the summer - usually at the end of week two and pay the loan back at the end of the 12 week season. The bank as usual is asking for projected revenue over the summer. Given the two weeks listed below, make a projection for the next 10 weeks. ( Hints: use (sin pi()*month/x)^2 and data for only days 1, 7 and 14 to get linear model)
Day Sales 1 204 2 218 3 230 4 236 5 235 6 232 7 234 8 244 9 258 10 270 11 276 12 275 13 272 14 274Explanation / Answer
Given Information :
Jack and Jill operate a small soft serve ice cream shop every summer in York, Me.
Plan for the upcoming summer:
They need to borrow operating cash from the local bank.
Policy used :
They borrow all that they need early in the summer - usually at the end of week two
Return Policy :
Pay the loan back at the end of the 12 week season.
Task :
The bank as usual is asking for projected revenue over the summer. Given the two weeks listed below, make a projection for the next 10 weeks.
Moving Avg Sales for 14 weeks
From this we can predict revenue fro next 10 weeks.
Day Sales 1 204 2 218 3 230 4 236 5 235 6 232 7 234 8 244 9 258 10 270 11 276 12 275 13 272 14 274 Avg of 14 weeks 247Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.