Reference no: EM131768951
Assignment
Each question is worth ten points. Please use additional paper if you need to while answering these questions. Please use the Thread City Café Project Excel spreadsheet to answer the following questions:
1. What is the average daily sales for the month?
2. What is the average daily food cost for the month?
3. What is the average daily employee hours for the month?
4. What is the correlation between daily sales and daily food cost?
5. What is the correlation between daily sales and daily employee hours?
6. Are daily food costs or daily employee hours more correlated with sales? Why do you think this is?
7. What is the Y intercept when X = 0 and the slope of a simple linear regression with daily sales being the independent variable (X) and daily food cost being the dependent variable (Y)?
8. What is the Y intercept when X = 0 and the slope of a simple linear regression with daily sales being the independent variable (X) and daily employee hours being the dependent variable (Y)?
9. Are daily food costs or daily employee hours more correlated with sales when analyzed by day? Why do you think this is?
10. What else can you say about these data?
|
Thread City Café Daily Report
|
|
|
|
|
|
|
Day of the Week
|
Sales
|
Food Cost
|
Employee Hours
|
|
|
|
|
|
|
Monday
|
$800
|
$199.00
|
16
|
|
Tuesday
|
$850
|
$212.50
|
16
|
|
Wednesday
|
$875
|
$218.00
|
16
|
|
Thursday
|
$925
|
$233.00
|
16
|
|
Friday
|
$975
|
$242.00
|
24
|
|
Saturday
|
$1,500
|
$378.00
|
40
|
|
Sunday
|
$2,800
|
$715.00
|
48
|
|
Monday
|
$775
|
$194.00
|
16
|
|
Tuesday
|
$845
|
$208.00
|
16
|
|
Wednesday
|
$874
|
$219.00
|
16
|
|
Thursday
|
$935
|
$234.00
|
16
|
|
Friday
|
$980
|
$248.00
|
24
|
|
Saturday
|
$1,450
|
$363.00
|
40
|
|
Sunday
|
$2,750
|
$688.00
|
48
|
|
Monday
|
$810
|
$205.00
|
16
|
|
Tuesday
|
$848
|
$213.00
|
16
|
|
Wednesday
|
$935
|
$240.00
|
16
|
|
Thursday
|
$940
|
$232.00
|
16
|
|
Friday
|
$985
|
$247.00
|
24
|
|
Saturday
|
$1,525
|
$380.00
|
40
|
|
Sunday
|
$2,850
|
$710.00
|
48
|
|
Monday
|
$825
|
$205.00
|
16
|
|
Tuesday
|
$863
|
$209.00
|
16
|
|
Wednesday
|
$880
|
$219.00
|
16
|
|
Thursday
|
$945
|
$237.00
|
16
|
|
Friday
|
$977
|
$245.00
|
24
|
|
Saturday
|
$1,532
|
$385.00
|
40
|
|
Sunday
|
$2,900
|
$725.00
|
48
|
|
Total
|
$35,149
|
$8,803.50
|
704
|
|
Determine the timing and amount of revenue recognition
: Easywrite Software Company shipped software to a customer on July 1, 2011. Determine the timing and amount of revenue recognition for the $243,000
|
|
Can the person be charged with multiple violations
: Assume a person accidentally picks up a credit card that is not theirs and uses the card in several instances.
|
|
Record the conversions using the book value method
: On January 1, 2017, Riverbed Corporation issued $4,020,000 of 10-year, 8% convertible debentures at 102. Interest is to be paid semiannually on June 30.
|
|
How anti-inequality and anti-poverty programs may lead
: Explain how anti-inequality and anti-poverty programs may lead to more income inequality and poverty in society. looking for more opinion.
|
|
What is the average daily employee hours for the month
: What is the average daily sales for month? What is the average daily employee hours for the month? What is correlation between daily sales and daily food cost?
|
|
Customer to settle a past-due account
: On November 1, Orpheum Company accepted a $12,500, 90-day, 33% note from a customer to settle a past-due account.
|
|
Basic financial statements to perform ratio analysis
: 1) How to analyze a firm using the basic financial statements to perform ratio analysis.
|
|
Calculate the mean and standard deviation for ounces
: Calculate the mean, median, and standard deviation for ounces in the bottles.Construct a 95% Confidence Interval for the ounces in the bottles.
|
|
Compute the ending inventory at retail
: Question -Retail Inventory Method, Compute a cost-to-retail percentage (Round to two decimals, e.g. 12.25.) under the Excluding both markups and markdowns
|