Question
1A ) Can you show how the journal entry for this transaction would look? (Purchased and sold) Invoice Date - October 26th Amount - 6,000
1A ) Can you show how the journal entry for this transaction would look? (Purchased and sold)
Invoice Date - October 26th
Amount - 6,000
Description - Credit Card Software 11.01.2020 - 10.31.2021
Actual 2020 | Budgeted 2020 | |||
USD | % | USD | % | |
Donuts | 100 | 27.0% | 100 | 27.5% |
Bear Claws | 150 | 27.5% | 150 | 27.0% |
Kolaches | 50 | 16.3% | 50 | 18.2% |
Long Johns | 100 | 45.0% [1] | 100 | 45.5% |
Total | 400 | 28.2% | 400 | 27.9% |
2A ) What do you think about the performance of the gross margin for the products?
2B ) Can you name three factors that can negatively affect the gross margin?
Actual 2020 | Budget 2020 | Actual 2019 | ACT 2020 - BGT2020 Value | ACT2020 - BGT 2020 % | ACT2020 - ACT2019 Value | ACT2020 - ACT 2019 % | |
Donuts | 100 | 110 | 90 | ||||
Bear Claws | 120 | 110 | 100 | ||||
Long John | 80 | 90 | 70 | ||||
Kolache | 100 | 80 | 95 | ||||
3A) Can you please find the variance for each product (in absolute value & %) between actual vs. budget and actual vs. 2019?
3B) Can you give a quick comment about the trend of the revenues and the related variances?
JAN | FEB | MARCH | APRIL | MAY | JUN | JUL | AUG | |
Phone | 0.48 | 0.67 | 0.87 | 1.22 | 1.17 | 0.58 | 0.24 | 0.29 |
Electric | 6.98 | 0.82 | 0.82 | 0.82 | 0.82 | 0.82 | 1.80 | 0.82 |
4A) What would you inquiry from the table above?
4B) What do you think we will spend in these catagories in the last 4 months of the year?
puud B27 f A B D F G H BGT AUG 2020 [USD k] 100 Donuts 150 ACT AUG 2020 [USD k] % 100 27.0% 150 27.5% 50 16.3% 100 45.0% [1] 400 28.2% Bear Claw Kolache Long John Total 50 27.5% 27.0% 18.2% 45.5% 27.9% 100 400 What do you think about the performance of the gross margin for our products? 1 5 Can you name three factors that can negatively affect the gross margin? 6 7 8 9 20 21 22 23 2A TEST STAFF AC Home Insert Page Layout Formulas Data Review View Colors Aal Width: 1 page Height: 1 page Scale: 6796 A Fonts Gridlines Headings V View 7 View Themes Breaks Background Print Titles Effects Margins Orientation Size Print Area Page Setup fx Print Print Sheet Options Bring to Send to Selection Front Back Pane Arrang Themes Scale to Fit L27 A B D E F G H 1 K L M 1 2 ACTUAL ACTUAL 2020 A ACT.20-BGT.20 VALUE % A ACT.20-ACT.19 VALUE % 2019 3 4 5 6 7 8 9 10 11 90 100 Values in [USD K] DONUTS BEAR CLAW LONG JOHN KOLACHE TOTAL BUDGET 2020 110 110 90 80 100 120 80 100 70 95 12 13 1) Can you please complete the cells FGHI to find the variance (in absolute value & %) between actual vs. budget & actual vs. 2019? 14 15 2) Can you give a quick and effective comment about the trend of the revenues and the related variances? 16 17 18 19 20 21 22 23 24 25 26 27 puud B27 f A B D F G H BGT AUG 2020 [USD k] 100 Donuts 150 ACT AUG 2020 [USD k] % 100 27.0% 150 27.5% 50 16.3% 100 45.0% [1] 400 28.2% Bear Claw Kolache Long John Total 50 27.5% 27.0% 18.2% 45.5% 27.9% 100 400 What do you think about the performance of the gross margin for our products? 1 5 Can you name three factors that can negatively affect the gross margin? 6 7 8 9 20 21 22 23 2A TEST STAFF AC Home Insert Page Layout Formulas Data Review View Colors Aal Width: 1 page Height: 1 page Scale: 6796 A Fonts Gridlines Headings V View 7 View Themes Breaks Background Print Titles Effects Margins Orientation Size Print Area Page Setup fx Print Print Sheet Options Bring to Send to Selection Front Back Pane Arrang Themes Scale to Fit L27 A B D E F G H 1 K L M 1 2 ACTUAL ACTUAL 2020 A ACT.20-BGT.20 VALUE % A ACT.20-ACT.19 VALUE % 2019 3 4 5 6 7 8 9 10 11 90 100 Values in [USD K] DONUTS BEAR CLAW LONG JOHN KOLACHE TOTAL BUDGET 2020 110 110 90 80 100 120 80 100 70 95 12 13 1) Can you please complete the cells FGHI to find the variance (in absolute value & %) between actual vs. budget & actual vs. 2019? 14 15 2) Can you give a quick and effective comment about the trend of the revenues and the related variances? 16 17 18 19 20 21 22 23 24 25 26 27
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started