Question
When beginning a spreadsheet-based calculation for a month-end adjusting journal entry, SprintyPrint often uses the previous month's spreadsheet as a starting point. That is, the
When beginning a spreadsheet-based calculation for a month-end adjusting journal entry, SprintyPrint often uses the
previous month's spreadsheet as a starting point. That is, the previous month's Excel file (e.g., Allowance_Calculation) is copied into a new folder (e.g., ''December calculation folder''). Alternatively, SprintyPrint could create template that contains logical formulas for making the calculation with no accounts receivable detail, and require their staff to start with this blank template for each month's calculation.
a. Why would someone choose to use a prior month's Excel file as a starting point rather than a template? What are some of the costs and benefits of using the prior month's file instead of a template?
b. Do you think that calculations would be less prone to errors if a template was used instead of the prior month's Excel file?
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